| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to use a variable for the criteria in a sumif function? | Excel Worksheet Functions | |||
| SUMIF function using Criteria on different worksheet | Excel Discussion (Misc queries) | |||
| Can I use two criteria in the SUMIF worksheet function? | Excel Discussion (Misc queries) | |||
| Help with SUMIF function criteria | Excel Worksheet Functions | |||
| Sumif function with two criteria from different columns | Excel Worksheet Functions | |||
Linear Mode
