# 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 a range

1.- condition 1: A kind of cost/payment such as: petrol, insurance,transport,energy supplies...

2.-condition 2: a center of cost where is applied. Every cente of cost has a number.

Is there any mistake in the formula

Thank you very much

5 Replies

# Re: SUMIFS reports value

It looks like you do it on 3 different tables, TOTAL, COST and CONT_NUMBER which shall not work. Perhaps you may share sample file or at least screenshot of what you'd like to do.

# Re: SUMIFS reports value

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"

Grateful

# Re: SUMIFS reports value

Why not base a pivot table on your data source. That would make is easy/quick to do the sums you want.

# Re: SUMIFS reports value

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]],
)``````

Syntaxis as COST[ [Amount]:[Amount] ] is equivalent of absolute reference.

Alternatively you may create PivotTable as @Thomas Kristiansen suggested. It's on top right.

Formulae above are in English, if you open attached in your environment they will be in your locale.

# Re: SUMIFS reports value

I 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.