Sum of If Results. How?
 

I need to get the SUM of all cell values on 1 cell, that have a Particular
value in another cell.
How do i do this?

EG.
Currently i use:
=C33+F33+I33+R33+U33.
However i need to get these values ONLY if another cell value has a certain
Value in it.
(These cells are C22,F22,I22,R22,U22). These are cells with a Validation
list with 2 options in it.
I ONLY want the sum of the values in the above (33 row's) IF the value in
row 22 in the same colomn is a certain value.

How do i do this ?


COrey....

Sum of If Results. How?
 

Assuming your values in row 22 is "Yes"
=SUMIF(C22:U22,"Yes",C33:U33)

Tony



Corey wrote:
I need to get the SUM of all cell values on 1 cell, that have a Particular
value in another cell.
How do i do this?

EG.
Currently i use:
=C33+F33+I33+R33+U33.
However i need to get these values ONLY if another cell value has a certain
Value in it.
(These cells are C22,F22,I22,R22,U22). These are cells with a Validation
list with 2 options in it.
I ONLY want the sum of the values in the above (33 row's) IF the value in
row 22 in the same colomn is a certain value.

How do i do this ?


COrey....

Sum of If Results. How?
 

Cheers.
Donme well Tony.

Corey....
"bony_tony" wrote in message
ups.com...
Assuming your values in row 22 is "Yes"
=SUMIF(C22:U22,"Yes",C33:U33)

Tony



Corey wrote:
I need to get the SUM of all cell values on 1 cell, that have a
Particular
value in another cell.
How do i do this?

EG.
Currently i use:
=C33+F33+I33+R33+U33.
However i need to get these values ONLY if another cell value has a
certain
Value in it.
(These cells are C22,F22,I22,R22,U22). These are cells with a Validation
list with 2 options in it.
I ONLY want the sum of the values in the above (33 row's) IF the value in
row 22 in the same colomn is a certain value.

How do i do this ?


COrey....