Dont include in sum if cell contains this value

E

exutable

Hey I am currently working on something, take a look
I want it to be like this: If B3=nosum then A3 is not included in the
sum at the bottom, take a look at the picture

Thanks guys!

4680


+-------------------------------------------------------------------+
|Filename: sum.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4680 |
+-------------------------------------------------------------------+
 
R

Ragdyer

I placed a <space> between "no" and "sum".

Change the formula or your data to match each other.
 

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 to calculate sum per category? 2
Sum with multiple conditions 6
If a cell contains a value then sum another cell. 3
help needed with "if" statement 2
To return value that provide data to a formula 1
If cell contains a value, multiply... 3
vlookup almost does this but not completely... 1
Auto populate 1

Top