How to count for 3 columns
Try this formula:
=SUMPRODUCT(--(A2:A6="In"),--(B2:B6="Comp1"),--(D2:D6="/"))
Repeat for each company, changing the "Comp1" portion.
HTH
Elkar
"Mysa" wrote:
Hi All,
I have this sheet:
Status Company Name Attendance
In Comp1 Jane /
In Comp1 Jack /
In Comp1 Peter D
Out Comp1 John
In Comp2 Peter /
...
I need count attendance "/" for status In and each company. Please can you
help?
Thanks,
Mysa
|