Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I am trying to find the sum of a column based on values from another column. For example, If I am inserting a sumif function in b5, and finding the sum of values b1:b4. I want the function to only sum the values in b1:b4 who have a corresponding d cell that is not blank. For instance, if b1=1, b2=2, b3=3, b4=4 and d1=5, d2 is blank, d3=4, d4 is blank. I only want the add b1 and b3 = 4. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
=sumif(d1:d4,"<",b1:b4)
JBoyer wrote: Hi, I am trying to find the sum of a column based on values from another column. For example, If I am inserting a sumif function in b5, and finding the sum of values b1:b4. I want the function to only sum the values in b1:b4 who have a corresponding d cell that is not blank. For instance, if b1=1, b2=2, b3=3, b4=4 and d1=5, d2 is blank, d3=4, d4 is blank. I only want the add b1 and b3 = 4. -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
When I tried this function it displayed a value of 0. Any other suggestions
would be appreciated. "Dave Peterson" wrote: =sumif(d1:d4,"<",b1:b4) JBoyer wrote: Hi, I am trying to find the sum of a column based on values from another column. For example, If I am inserting a sumif function in b5, and finding the sum of values b1:b4. I want the function to only sum the values in b1:b4 who have a corresponding d cell that is not blank. For instance, if b1=1, b2=2, b3=3, b4=4 and d1=5, d2 is blank, d3=4, d4 is blank. I only want the add b1 and b3 = 4. -- Dave Peterson |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
And if you just use =sum(b1:b4), what do you get?
If that's 0 (and it shouldn't be), then maybe your "numbers" are text. Format the cells as General and then retype those entries and try both formulas. Or maybe d1:d4 are all empty??? JBoyer wrote: When I tried this function it displayed a value of 0. Any other suggestions would be appreciated. "Dave Peterson" wrote: =sumif(d1:d4,"<",b1:b4) JBoyer wrote: Hi, I am trying to find the sum of a column based on values from another column. For example, If I am inserting a sumif function in b5, and finding the sum of values b1:b4. I want the function to only sum the values in b1:b4 who have a corresponding d cell that is not blank. For instance, if b1=1, b2=2, b3=3, b4=4 and d1=5, d2 is blank, d3=4, d4 is blank. I only want the add b1 and b3 = 4. -- Dave Peterson -- Dave Peterson |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Sorry for the confusion, I knew the formula should work but I didn't
understand why it wouldn't. But, yes the cells were formated as general and I had to change them to number format. Again, thanks for the initial help and the response to my stupidity. "Dave Peterson" wrote: And if you just use =sum(b1:b4), what do you get? If that's 0 (and it shouldn't be), then maybe your "numbers" are text. Format the cells as General and then retype those entries and try both formulas. Or maybe d1:d4 are all empty??? JBoyer wrote: When I tried this function it displayed a value of 0. Any other suggestions would be appreciated. "Dave Peterson" wrote: =sumif(d1:d4,"<",b1:b4) JBoyer wrote: Hi, I am trying to find the sum of a column based on values from another column. For example, If I am inserting a sumif function in b5, and finding the sum of values b1:b4. I want the function to only sum the values in b1:b4 who have a corresponding d cell that is not blank. For instance, if b1=1, b2=2, b3=3, b4=4 and d1=5, d2 is blank, d3=4, d4 is blank. I only want the add b1 and b3 = 4. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
sumif | Excel Discussion (Misc queries) | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |