PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Crashes I can't return blank cells with formulas.

Reply

I can't return blank cells with formulas.
 
Thread Tools Rate Thread
Old 03-06-2004, 04:51 PM   #1
=?Utf-8?B?dGhyaWxh?=
Guest
 
Posts: n/a
Default I can't return blank cells with formulas.


I am trying to get specific fields to add if and only if specific cells aren't blank. I have tried to use the SUMIF function to add the cells only if they are greater than 0, but it only gives me errors. I have tricked it before, but it was a pain and for some reason I can't trick this version of Excel. Any suggestions would be greatly appreciated
  Reply With Quote
Old 03-06-2004, 05:53 PM   #2
Charlie
Guest
 
Posts: n/a
Default Re: I can't return blank cells with formulas.
Try
=SUMIF(B3:B10,">0",B3:B10)

Charlie O'Neill
>-----Original Message-----
>I am trying to get specific fields to add if and only if
specific cells aren't blank. I have tried to use the
SUMIF function to add the cells only if they are greater
than 0, but it only gives me errors. I have tricked it
before, but it was a pain and for some reason I can't
trick this version of Excel. Any suggestions would be
greatly appreciated
>.
>
  Reply With Quote
Reply

Archive


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off