Combine SUM and LOOKUP across multiple sheets

[jodybingo]

I have multiple tabs representing the month & year (Mar_2024, Apr_2024, May_2024 etc) containing alcohol products. With the occasional introduction and removal of alcohols and the list being in alphabetical order, they aren’t always on the same row.
How can I combine a sum and lookup function function that would span multiple tabs?

Thanks
J

[fpy]

@jodybingo

tabs

a.k.a. sheets

@jodybingo

month & year

sort of FAQ.

you may consider simplifying / normalizing in 1 sheet, and Applying AutoFilter
then use a similar solution to consolidate :

Libreoffice Calc Sum of values depending of month and year of a range of dates

SUMPRODUCT is your friend. Assuming dates in C2:C9 and numbers in E2:E9 this sums values for month May =SUMPRODUCT(MONTH(C2:C9)=5,E2:E9) and this sums values for year 2017 =SUMPRODUCT(YEAR(C2:C9)=2017,E2:E9) To sum only negative or positive values just add another condition, like =SUMPRODUCT(MONTH(C2:C9)=5,E2:E9<0,E2:E9) for negative values and =SUMPRODUCT(MONTH(C2:C9)=5,E2:E9>0,E2:E9) for positive values. To sum all positive values in the month May of the year 2017 =SUMPRODUCT(YEAR(C2:C9)=201…