SumIf

J

Jeff Mackeny

I'm using the following Sum if formula '=SUMIF(D1,"on",MasterList!C4)', if
D1 is not "on" it returns 0, how to I make it blank
 
J

JulieD

Hi Jeff

not sure why you're using a sumif formula i would do it this way
=IF(D1="on",MasterList!C4,"")

Cheers
JulieD
 
J

Jason Morin

You could custom format that cell to be:

General;General;;@

HTH
Jason
Atlanta, GA
 
J

Jeff Mackeny

Thanks it worked

Julie, can I email you this workbook im working on, so you can help,
suggest, modify etc.
 
J

Jeff Mackeny

Julie,

One more question, if I sum 2 blank cell it returns #VALUE!, I need to the
sum the formula because it will trough time have numbers in it.
 
J

Jeff Mackeny

Correction to my last question, its a blank cell but has a reference to
another sheet, for example Feb K4 has =Jan!F4, Feb L4 has =Jan!I4, now Feb
M4 has =J4+K4+L4, K4 and L4 is currently blank, M4 now returns #VALUE!
 
J

JulieD

Hi Jeff

sorry went to bed - well, it was 3am :)

feel free to email me the workbook direct and i'll have a look for you.

Cheers
JulieD
 

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

Use TODAY() function as the criteria in a SUMIF formula 1
Combine Sumifs with Subtotal 0
SUMIF with criteria "<>" & "=" 4
SumIf equation question 6
Count Number of Unique Cells That Don't Have Certain Characters 0
Specifying comparision criteria with SUMIF() 2
Month wise Sum 4
Help needed regarding calculating time 0

Top