=SUMPRODUCT Question

J

JAgger1

I've been using =SUMPRODUCT(--(COUNTIF(A1:A1000,B1:B30)>0)) to compare
two sets of numbers for matching numbers. Is there a way to expand
this formula to compare 3 or more sets of numbers for matching
numbers? I've tried using it on 3 sets of numbers and keep getting the
error "You've entered too many arguements for this function".
 
V

Vacuum Sealed

Try this

=IF($C87=0,0,SUMPRODUCT(--(Historical!$A$2:$A$9997="A"),--(Historical!$C$2:$C$9997="B"),--(Historical!$K$2:$K$9997)))

This will sum

Also

=IF($C87=0,0,SUMPRODUCT(--(Historical!$A$2:$A$9997="A"),--(Historical!$C$2:$C$9997="B"))

This will Count

HTH
Mick
 

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

=Sumproduct Question 0
Sumproduct Problem 4
SUMPRODUCT Error 2
Removing Sequential Numbers 5
Copy Matching Numbers To New Cell's 5
Match issue 3
Number Match Formula? 7
WORD VBA Search and switch to advanced ... 1

Top