hello,
I wonder if someone can give me a tip how to count for an item in specific year. screenshot.6199.jpg
i used formula:
=SUMIFS(F2:F69, D2:D69, "banana", A2:A69, "1996*")
but i guess i cant use 1996* like this.
thank you
hello,
I wonder if someone can give me a tip how to count for an item in specific year. screenshot.6199.jpg
i used formula:
=SUMIFS(F2:F69, D2:D69, "banana", A2:A69, "1996*")
but i guess i cant use 1996* like this.
thank you
Last edited by Excl3454; 05-04-2021 at 12:17 PM.
Using SUMPRODUCT
=SUMPRODUCT(F2:F69, (D2:D69= "banana")*(YEAR( A2:A69)=1996))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks