SUMIF function criteria options

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!
 
B

BDP

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

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
 
D

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top