SUMIF function criteria options
 

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!

SUMIF function criteria options
 

=SUMIF(CriteriaRange,"intercompany",SumRange)


"BDP" wrote:

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!

SUMIF function criteria options
 

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

"Teethless mama" wrote:

=SUMIF(CriteriaRange,"intercompany",SumRange)


"BDP" wrote:

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!

SUMIF function criteria options
 

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

On Nov 26, 6:34 pm, BDP wrote:
Thanks for the response. How do I specify that the criteria Intercompany is
from a different column?



"Teethless mama" wrote:
=SUMIF(CriteriaRange,"intercompany",SumRange)

"BDP" wrote:

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!- Hide quoted text -

- Show quoted text -

SUMIF function criteria options
 

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)


"Pete_UK" wrote:

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

On Nov 26, 6:34 pm, BDP wrote:
Thanks for the response. How do I specify that the criteria Intercompany is
from a different column?



"Teethless mama" wrote:
=SUMIF(CriteriaRange,"intercompany",SumRange)

"BDP" wrote:

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!- Hide quoted text -

- Show quoted text -