SUMIF function criteria options

[BDP]

I want to sum a column of data based on the condition of a different columns.
I am trying to use the SUMIF function but cannot figure out how to construct
the criteria for this. I am simply trying to say (for the criteria) if
column x = "intercompany". Can someone help with this? Thanks so much!

 

[Teethless mama]

=SUMIF(CriteriaRange,"intercompany",SumRange)

 

[BDP]

Thanks for the response. How do I specify that the criteria Intercompany is
from a different column?

 

[Pete_UK]

The CriteriaRange is the column where your descriptions can be found -
suppose this is column X. The SumRange is the column that you want to
add up if the criteria is met - suppose this is column M. Your formula
would be:

=SUMIF(X2:X100,"intercompany",M2:M100)

i.e. add up the values from column M IF the corresponding cells of
column X equal "intercompany".

Hope this helps.

Pete

 

[daddylonglegs]

If you want to use a cell reference, i.e. the word intercompany is in cell Y1
then to sum column Z try

=SUMIF(X:X,Y1,Z:Z)