Multiple Countif results
Cheers Scott
Worked a treat
FtB
"Scott" wrote:
Hello,
I think you want this:
=SUMPRODUCT(--(Sheet1!B:B="Staff Group A"), --(Sheet1!C:C="Criteria A"))
see if this works.
Cheers,
Scott
"Fez the Blue" wrote:
My heads hurting trying to sort this one out, and the answer will be so
obvious...but can anyone clear this up for me
I need to record multiple results based on set criteria being met i.e the
total number of Criteria A's for Staff Group B, Criteria A's for Staff Group
A and so on.
Staff Group A Criteria A
Staff Group B Criteria A
Staff Group A Criteria A
Staff Group B Criteria B
Staff Group B Criteria B
I've tried =SUMPRODUCT(--(Sheet1!B:B="Staff Group A")*(Sheet1!C:C="Criteria
A")) but keep getting #Num
Can anyone help
FtB
|