Posted to microsoft.public.excel.worksheet.functions

Elkar

external usenet poster

Posts: 964

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count in two columns	[email protected]	Excel Worksheet Functions	6	February 3rd 07 03:57 PM
Highlighted Columns Count!	KC Rippstein hotmail com>	Excel Discussion (Misc queries)	2	January 11th 07 02:49 PM
How to count data in 2 columns	Ltat42a	Excel Discussion (Misc queries)	20	May 31st 06 05:55 PM
Sum/Count Multiple columns	Tom Hewitt	Excel Discussion (Misc queries)	6	March 14th 06 03:10 PM
Count certain changes between columns	SLB	Excel Worksheet Functions	1	November 1st 04 08:54 PM

All times are GMT +1. The time now is 05:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us