Hi!
Try this:
=SUMPRODUCT(--(Sheet1!A1:A100="name"),--(Sheet1!
B1:B100="product"),--(Sheet1!C1:C100="score"))
Biff
-----Original Message-----
Ok, On Tab A I have my raw data that has three columns
I'm interested in:
Name
product
score
I'm breaking the info down in Tab B.
I have a countif set up already to tell me how many of
any given "name" or
"product" there are in their respective columns. How
would I tell it to
count all instances of a specific "score" value(s)
associated with a "name"
or "product" though?
.
|