Forum Discussion
Combining two Functions
=COUNTIF(B2:B15,"Cooking Dinner") Returns all count Cooking Dinners =SUMPRODUCT(1*(YEAR(A2:A15)=2023)) Returns all count of year 2023 I would like to count how many times “Cooking Dinner...
I think this should have been posted in the Excel forum. https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral