Forum Discussion

PJGUDEL's avatar
PJGUDEL
Copper Contributor
Sep 01, 2024

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.

Resources