Forum Discussion
Solved
SUMIF [sum_range] select different columns
Hi to everyone! First of all, thank you for your help! I have been struggling with a SUMIF formula (SUMAR.SI in Spanish) As you know, the syntax of the formula is SUMIF(range, criteria, [sum_ra...
If you do need the Dynamic Range option then I've attached an example file of how you could do it
Hi Angela,
Are you using SUMIF becuase there will be multiple rows with values for items like Presupuesto and Venta Semana? If not then then there may be an alternative way using INDEX MATCH MATCH
If there will be multiple occurrences then another simpler approach would be to use Power Query to "unpivot" the data so the months end up in a single column rather than across the columns. Then a simple SUMIFS formula would work.
Is this an option for you?
Let me know and I can advise further
Wyn
Are you using SUMIF becuase there will be multiple rows with values for items like Presupuesto and Venta Semana? If not then then there may be an alternative way using INDEX MATCH MATCH
If there will be multiple occurrences then another simpler approach would be to use Power Query to "unpivot" the data so the months end up in a single column rather than across the columns. Then a simple SUMIFS formula would work.
Is this an option for you?
Let me know and I can advise further
Wyn