Forum Discussion

AdolfoMartinez's avatar
AdolfoMartinez
Copper Contributor
Jun 08, 2023

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 

Formulas and Functions

5 Replies

  • thomasbkdk's avatar
    thomasbkdk
    Brass Contributor
    Jun 08, 2023
    Why not base a pivot table on your data source. That would make is easy/quick to do the sums you want.
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jun 08, 2023

    AdolfoMartinez 

    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.

    • AdolfoMartinez's avatar
      AdolfoMartinez
      Copper Contributor
      Jun 08, 2023

      SergeiBaklan 

      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's avatar
        SergeiBaklan
        Diamond Contributor
        Jun 08, 2023

        AdolfoMartinez 

        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.

Resources