Sum Product and Count IF . is this possible?

[Raj1313]

HI I have the below formula working fine :

=SUMPRODUCT((MONTH(A:A=$C$64)*1)) - This finds all entries which are December in a list of dates.

I want to add a count IF to it which is =COUNTIF(A:A,D57) - is this possible?

 

[steve the fish]

Unless the D57 has a date in December it will produce 0 or if in December the countif can be used on its own from what I can see. You are testing the same range with both formulae.

 

[Aladin Akyurek]

What do you have in C64 and in D57 exactly and what do you mean by adding?

 

[Raj1313]

C64 relates to December and D57 is just text. I need the formula to find all the text (D57) from column (B;B) MTD and also only include records MTD from the date column (A:A). if that makes sense

 

[steve the fish]

C64 relates to December? What does that mean? What is in cell C64 exactly?

 

[Raj1313]

C64 is "December" the month n a date format of MMM

 

[steve the fish]

What appears in the formula bar? We need the cell value not its appearance after formatting. MMM should produce Dec not December.

 

[Raj1313]

The Cell Value is =Today() which produces December after formatting it to mmmm

 

[steve the fish]

Try:

=COUNTIFS(B:B,D57,A:A,">="&EOMONTH(C64,-1)+1,A:A,"<"&EOMONTH(C64,0)+1)