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

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

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

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

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,D2:D4,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

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,D2:D4,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