Count unique days on condition that they are Mondays

Hi all,

I am dealing with an issue that has been discussed (and solved) many times on the ExcelForum. However, none of the previous solutions seem to work for me. Regardless, my problem appears quite straightforward, further adding to my frustration.

In my spreadsheet, Column A holds a list of dates, many of which appear more than once.
Column B holds the weekdays for the associated dates in column A, which are simply written out ("Monday", "Tuesday" etc.).
I would like Excel to compute the number of unique dates that is also a Monday anywhere in column C.
I am able to count the total number of unique dates with the SUM(1/COUNTIF(A...:A...;A...:A...)) function, but adding the condition that I only want those dates counted that are also a Monday is a problem. I feel like I tried everything.

If possible, I would like to complete this step without any helper columns or pivot tables. Just a single formula would be ideal.

Thanks in advance,

Stijn

You could probably use COUNTIFS to apply two separate conditions to the function, but I am really not sure.

Is manipulating your data an option, using a tool like demove duplicates, then applying the COUNTIF formula?

=COUNTIFS(Range 1, Criteria 1, Range 2, Criteria 2)

I am not sure I really understand exactly what you are trying to achieve. Could you post a sample of your workbook?

@ Fotis1991:

Thank you very much, I have no idea how this formula works but I am almost there! Right now, your solution returns 0,34 (I in fact have 34 unique Mondays in my spreadsheet) and I would like it to simply return 34 to the cell. Would you know how I could do that?

@Fotis1991
Haha, no I meant (0,34) like a one row, two column matrix. But I figured it out, thank you very much!

Stijn


P.S. If you or anyone else ever finds the time to explain to me how the formula actually works -- I would love to know.