Posted to microsoft.public.excel.misc

Fred Smith Fred Smith is offline

external usenet poster

Posts: 623

Sum if not null

I would like to sum all cells which are non-blank (same as selecting non-blank
cells in a filter). I tried

=sumif(A:A,"<""""",B:B)

but Excel didn't think much of it.

What is the correct criteria for 'not null'?

--
Regards,
Fred

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
visual basic within Access If...Then	arabella79	Excel Discussion (Misc queries)	1	October 5th 06 09:34 PM
visual basic within Access If...Then	arabella79	Excel Discussion (Misc queries)	0	October 5th 06 09:24 PM
VLookup Null values	Babylooch	Excel Worksheet Functions	4	September 11th 06 03:43 PM
Null values in charts and how to override the goal seek functionality	Sarge	Charts and Charting in Excel	1	January 27th 06 03:57 AM
Multipying columns that contail null values	ChuckW	Excel Discussion (Misc queries)	1	September 7th 05 01:13 AM

All times are GMT +1. The time now is 10:25 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us