Forum Discussion
AdolfoMartinez
Jun 08, 2023Copper Contributor
SUMIFS reports value
Good morning i am using sumif in spanish with this formula =SUMAR.SI.CONJUNTO(TOTAL[Amount];COST[COST];COST[@COST];CONT_NUMBER[CONT_NUMBER];CONT_NUMBER[@[CONT_NUMBER]]) There are 2 conditions and...
AdolfoMartinez
Jun 08, 2023Copper Contributor
Hello
the photo show a total of registers
What i need to do is to "sumif" following kind of cost and month in another tab to gather all data by these concepts
But the file show "value"
Thank you for answering
Grateful
SergeiBaklan
Jun 08, 2023MVP
For such sample
if upper table name is COST formula for January in another TOTAL table could be
=SUMIFS(
Cost[ [Amount]:[Amount] ],
Cost[ [Kind of Cost]:[Kind of Cost] ], Total[@[COST]:[COST]],
Cost[ [Month]:[Month] ], Total[[#Headers],[January]]
)
Syntaxis as COST[ [Amount]:[Amount] ] is equivalent of absolute reference.
Alternatively you may create PivotTable as thomasbkdk suggested. It's on top right.
Formulae above are in English, if you open attached in your environment they will be in your locale.
- AdolfoMartinezJun 13, 2023Copper ContributorI have another way to solve it
i read in microsoft support page that all table must have the same range. I chose all references for the formula in the same table and works.
i am going to try with this solutions you gave me.
Revert soon with answer
Depply Grateful
Thank you very much