Forum Discussion
PJGUDEL
Sep 01, 2024Copper Contributor
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 Dinners” is in the year 2023. Or count all “Cooking” in the year 2024 no matter of if it is lunch or dinner.
- I think this should have been posted in the Excel forum. https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral