Forum Discussion
Countif
I need help with a formula: In cell with ?...If column "A" matches "A2" and matches "C1", count column "C". The return should be 4 0 1 11/1/2021 ? 11/1/2021...
OliverScheurich Thank you much...I'm still not sure why this doesn't work...could it be my column "C" is formatted for "Hour"?
Does it work when you open the attached file?
I assume you don't work with the german version of Excel and that's why SUMMENPRODUKT returns the #Name error in your sheet.
If you work with the english version of Excel you can enter formula:
=SUMPRODUCT((MONTH(A5:A13=C1)*(A5:A13=A2)*C5:C13))
- I copied and paste it and I keep getting zero as a result...thank you anyways, I appreciate it. Maybe something is wrong with my file.