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

G

Guest

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.
 
G

Guest

Assume the values you want to sum are located in column D:

=SUMPRODUCT(--(A1:A100=1),--(B1:B100=0),--(C1:C100=1),D1:D100)
 
G

Guest

Assume the values you want to sum are located in column D:

=SUMPRODUCT(--(A1:A100=1),--(B1:B100=0),--(C1:C100=1),D1:D100)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Values from different column 1
Sum totals 2
Time Sum in Excel 1
Subject: Summing one column where criteria in two other 1
Summing 2 columns based on variables 3
Sum Products with VLOOKUP 3
Excel 2000 formula to dynamically sum adjacent rows and columns whererows inserted/deleted 2
Indirect Sum 3

Top