View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shahbaze Shahbaze is offline
external usenet poster
 
Posts: 2
Default How do I use 3 separate column qualifiers to sum? IF statements?

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.