Thread: Using Countif
View Single Post
  #2   Report Post  
Biff
 
Posts: n/a
Default

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