How do I use 3 separate column qualifiers to sum? IF statements?

=?Utf-8?B?U2hhaGJhemU=?=

Guest

Posts: n/a

18th Sep 2006

I am trying use 3 columns, from another tab, as qualifiers to obtain sum.
Example, look at column A for all 1s, look at column B for all the "0"s and
look column C for all the "1"s. From those qualifiers, obtain a sum. I have
tried to use a "Sum" statement with IF embedded in the formula, but I get the
message "too many arguments for this function. I would appreciate if anybody
can help me.

« how do I get rid of blue asterick in create list? | IF Function (.......... »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
multiple qualifiers for If statements	Matthew Dyer	Microsoft Excel Programming	5	4th Nov 2009 03:34 AM
Join statements using ADO across separate Worksheets	gimme_this_gimme_that@yahoo.com	Microsoft Excel Programming	3	6th Nov 2006 06:06 PM
How do I use 3 separate column qualifiers to sum? IF statements?	=?Utf-8?B?U2hhaGJhemU=?=	Microsoft Excel Worksheet Functions	2	18th Sep 2006 06:55 PM
Minimum qualifiers to Find (VBA) the actual last used Row, Column	EagleOne	Microsoft Excel Misc	3	31st Jul 2006 04:51 PM
two separate insert statements - only one works	leah f via AccessMonster.com	Microsoft Access VBA Modules	1	9th Feb 2005 12:46 PM