View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Powlaz
 
Posts: n/a
Default Sumif Cells Are Not Blank

Kevin, Andy, thanks for the quick responses. Both of your formulas worked
(as far as I can tell). I'm interested in understanding how they work if you
could offer a quick explanation.

Moreso, I need a little more help. Both the formulas returned a 0 when
summing a range of blank cells. Here's the issue, this spreadsheet is pre -
formatted for a year's worth of data. I'd like for the cells in an unused
month to remain blank until the data is entered (and subsequently
calculated).

There is currently no user added data in cells b6:b12. But cell b13 that
calculates the total of b6:b12 shows 0. I'd like it to be blank until data
is entered into b6:b12. How can I concisely do that?

I thought about using IF and OR functions combined so that each cell is
checked for a value greater than "" before it will calculate the total of the
cells but it's very long and I think inefficient.

Got anything else?

Thanks

PO
"AndyB" wrote:

Hi

Try something like this:
=SUMPRODUCT((D7:G70)*(D7:G7))

AndyB

"Powlaz" wrote in message
...
I'm looking to total a range of cells ONLY if they have a value of 0 or
more
entered in them. In plain english:

Sumif A1 is =0
Sumif A2 is =0
Sumif A3 is =0

and so on. Where every cell in the range must have a value of 0 or more
entered before the function will return a result. How do I do this?

Thanks,

PO