Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Out of memory exception | Excel Discussion (Misc queries) | |||
WHAT ARE THE CAUSES FOR 'EXCEPTION ERROR ' | Excel Discussion (Misc queries) | |||
handle #VALUE exception | Excel Worksheet Functions | |||
Exception deleting | Excel Discussion (Misc queries) | |||
formula w exception | Excel Discussion (Misc queries) |