Hello,
i've been working on a "to-be" dashboard for a long time, and i'm now stuck on a sum i need to do based on the selection of four segment
the criteria are generated in 4 differente tables from a UNIQUE(Filter formula
i need a first sum based on the criteria affecting the column " Client ", " Carrier " and " Temperature " regardless of the range" imputation "
and another one based on the same thing, but with the column " imputation " added
i've tried with Sum(SumIFS , but it seem sumifs can't work with this many criteria
i've tried to look at sumproduct but i don't really understand how it work
could you please look at my file and tell me where i'm going wrong ?
thanks in advance,
Bookmarks