convert Sumifs to sumproduct or similar

Originally Posted by Stephen Reeves

Hi XLent, Thanks for this suggestion do you mean like this? =SUBTOTAL(2,[Dates] ('2021'!$AD$15:$AD$493,Dates,">="&F$2,Dates,"<"&EDATE(F$2,1),WalletType, "="&$C4)

Hi, no; the SUBTOTAL field would reside on your Data tabs, directly -- that 0/1 field would then be referenced in your various SUMIFS with a fixed criteria of 1 (visible)

Refer attached for working example -- note, the file has 3 tables, 2020 + 2021 and then a further table which = either 2020 or 2021 based on selection thereby avoiding need for INDIRECT {volatile, like OFFSET approach}

hopefully this gives you some idea.... the results will adjust relative to year, and filter applied on source data tab