If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sum in a column if there are 3 conditions in another column
I need to find the total from Col B if Col A is one of the 3 possibilities
A B DONE 0 DONE 60 OBS 40 POST 55 DONE 40 DONE 0 DONE 47 POST 55 DONE RESULT OBS RESULT POST RESULT |
#2
|
|||
|
|||
Sum in a column if there are 3 conditions in another column
Try the below for total for "Post"
=SUMIF(A:A,"Post",B:B) 'Try the below for total of all three =SUM(SUMIF(A:A,{"Post","OBS","Done"},B:B)) -- Jacob (MVP - Excel) "DogmaDot" wrote: I need to find the total from Col B if Col A is one of the 3 possibilities A B DONE 0 DONE 60 OBS 40 POST 55 DONE 40 DONE 0 DONE 47 POST 55 DONE RESULT OBS RESULT POST RESULT |
#3
|
|||
|
|||
Sum in a column if there are 3 conditions in another column
To sum for "done"...
=SUMIF(A1:A10,"done",B1:B10) -- Biff Microsoft Excel MVP "DogmaDot" wrote in message ... I need to find the total from Col B if Col A is one of the 3 possibilities A B DONE 0 DONE 60 OBS 40 POST 55 DONE 40 DONE 0 DONE 47 POST 55 DONE RESULT OBS RESULT POST RESULT |
#4
|
|||
|
|||
Sum in a column if there are 3 conditions in another column
Hi Jacob,
A quick question Is it possible to replace the criteria inside the curley brackets with cell references (I'm getting an error message)? Thanks Paul "Jacob Skaria" wrote: Try the below for total for "Post" =SUMIF(A:A,"Post",B:B) 'Try the below for total of all three =SUM(SUMIF(A:A,{"Post","OBS","Done"},B:B)) -- Jacob (MVP - Excel) "DogmaDot" wrote: I need to find the total from Col B if Col A is one of the 3 possibilities A B DONE 0 DONE 60 OBS 40 POST 55 DONE 40 DONE 0 DONE 47 POST 55 DONE RESULT OBS RESULT POST RESULT |
#5
|
|||
|
|||
Sum in a column if there are 3 conditions in another column
Hi Paul,
you could replace the criteria with a range if you used SUMPRODUCT instead of SUM. =SUMPRODUCT(SUMIF(A:A,D24,B:B)) "Dazed&Confused" wrote in message ... Hi Jacob, A quick question Is it possible to replace the criteria inside the curley brackets with cell references (I'm getting an error message)? Thanks Paul "Jacob Skaria" wrote: Try the below for total for "Post" =SUMIF(A:A,"Post",B:B) 'Try the below for total of all three =SUM(SUMIF(A:A,{"Post","OBS","Done"},B:B)) -- Jacob (MVP - Excel) "DogmaDot" wrote: I need to find the total from Col B if Col A is one of the 3 possibilities A B DONE 0 DONE 60 OBS 40 POST 55 DONE 40 DONE 0 DONE 47 POST 55 DONE RESULT OBS RESULT POST RESULT |
#6
|
|||
|
|||
Sum in a column if there are 3 conditions in another column
Hi Steve,
The trouble with SUMPRODUCT is that it eats memory and slows this ancient PC to a crawl. Oh well Paul "Steve Dunn" wrote: Hi Paul, you could replace the criteria with a range if you used SUMPRODUCT instead of SUM. =SUMPRODUCT(SUMIF(A:A,D24,B:B)) "Dazed&Confused" wrote in message ... Hi Jacob, A quick question Is it possible to replace the criteria inside the curley brackets with cell references (I'm getting an error message)? Thanks Paul "Jacob Skaria" wrote: Try the below for total for "Post" =SUMIF(A:A,"Post",B:B) 'Try the below for total of all three =SUM(SUMIF(A:A,{"Post","OBS","Done"},B:B)) -- Jacob (MVP - Excel) "DogmaDot" wrote: I need to find the total from Col B if Col A is one of the 3 possibilities A B DONE 0 DONE 60 OBS 40 POST 55 DONE 40 DONE 0 DONE 47 POST 55 DONE RESULT OBS RESULT POST RESULT |
Thread Tools | |
Display Modes | |
|
|