Posted to microsoft.public.excel.misc

JPDS

external usenet poster

Posts: 29

Counting Blanks

Has Excel always counted blanks under the following condition?:

{=sum((range1=condition1)*(cond2result2))}

where result2 could contain blanks to allow for errors in a calculated result?

I know that I can amend the formula so that blanks are excluded but I never
expected blanks to be counted.

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
counting non-blanks	DJK Moore	New Users to Excel	2	January 8th 09 10:22 PM
counting blanks	Paul	Excel Worksheet Functions	1	December 10th 06 02:14 AM
Counting blanks, either 1, 2 or 3	Steve	Excel Worksheet Functions	5	January 14th 06 02:18 AM
Counting Blanks	T De Villiers	Excel Worksheet Functions	2	August 23rd 05 02:34 PM
If Then, not using values, or not counting blanks	Need Help 123	Excel Worksheet Functions	8	July 20th 05 06:23 PM

All times are GMT +1. The time now is 07:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us