Posted to microsoft.public.excel.misc

Cue

external usenet poster

Posts: 47

Sum Based on Exception

The results of the following formula is 0 when column G has values in it.

=SUM(IF($B$6:$B$65536="John Doe",IF($B$6:$B$65536="Jane
Dane",IF($B$6:$B$65536="Jack Dark",IF($G$6:$G$65536<"",0,1)))))

Can someone please show me what I am missing or don't need in the formula in
order to get the right sum?
--
Cue

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
Sum Based on Exception	Cue	New Users to Excel	9	May 22nd 08 12:44 AM
WHAT ARE THE CAUSES FOR 'EXCEPTION ERROR '	CAPTGNVR	Excel Discussion (Misc queries)	0	January 29th 07 06:04 PM
handle #VALUE exception	Andis Cirulis	Excel Worksheet Functions	2	November 13th 06 11:32 AM
Exception deleting	cj21	Excel Discussion (Misc queries)	5	January 26th 06 04:05 PM
formula w exception	Micayla Bergen	Excel Discussion (Misc queries)	3	May 18th 05 03:23 AM

All times are GMT +1. The time now is 03:04 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us