SUMIF function criteria options

  • Thread starter Thread starter BDP
  • Start date Start date
B

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!
 
Thanks for the response. How do I specify that the criteria Intercompany is
from a different column?
 
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
 
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)
 
Back
Top