Sum of If Results. How?

  • Thread starter Thread starter Corey
  • Start date Start date
C

Corey

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....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I get around 30 argument limit of SUM function? 4
IF function, nested with 2 source cells? 5
Sum with condition 3
How do I sum cells that have values from a text formula? 4
Random #VALUE! error in simple SUM formula results 3
sun results of a vlookup across a range 3
XL2002 SUM with a twist... 4
Sum of rows in different columns 3

Back
Top