Brian Barker wrote:
At 16:54 24/10/2008 -0600, Walter Hildebrandt wrote:
Brian Barker wrote:
... and then sum them with =SUMIF(C1:C99;">0") instead of =SUM(C1:C99).
I tried the SUMIF formula .
I suspect you may have tried something other than my SUMIF() formula!
Err: 508 comes up with the , before the >
Err: 510 comes up with the ; before the >
Why, please, did you choose to change my formula by omitting the
double quotation marks?
At 17:06 24/10/2008 -0600, Walter Hildebrandt wrote:
This is my second reply to your E-mail.
Indeed it is ...
The spreadsheet would work better if the column could be added by a
SUMIF formula. Is there a SUMIF formula that would work at the
bottom of the column?
Yes: try the formula I suggested.
;^)
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
I goofed and left out the double quotation marks. Your formula worked
fine. The problem was me. Thank you for hanging in there.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
