How to count for 3 columns
 

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

How to count for 3 columns
 

Try something like this:

=SUMPRODUCT(--(A2:A10="in"),--(B2:B10="Comp1"),--(D2:D10="/"))


--
Biff
Microsoft Excel MVP


"Mysa" wrote in message
...
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

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