SUM 2 cells only if there is a value in both

  • Thread starter Thread starter milt
  • Start date Start date
M

milt

I want to SUM two cells in an Excel worksheet but only if there is a value in
both cells. For each month of the year I want to show total minutes (B32:43)
less minutes used (D32:43). The answer will be in (E32:43). However if I use
the simple SUM function =SUM(B32-D32) I get the total minutes in Column E if
there is nothing in column D. I've looked at SUMIF but cannot figure out how
to use it for this purpose. Thanks for your help.
 
Hi,

You don'r need sum to subtract a number from another, try this

=IF(COUNT(B32,D32)=2,B32-D32,"")


Mike
 

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

Sum Workdays 5
Worksheet Formula Returning Sum of a Series 16
How do it set up a SUMIF equation with 2 conditions 5
use month in cell date to sum all relevant cells 2
Excel formula, sum the value cell and if empty cell left blank 0
Condition formulas for multiple columns 2
Different results from AVG funtion 3
sum if function 1

Back
Top