Counting Text Occurances - HELP PLEASE

[Beauty Girl]

I have numerous (approx. 30) 2 letter codes used to identify different type
of work events. Some are "soft" events, some are "hard" events. I want to
count how many times each type of event occurs in a range.

Soft = DO, VC, SK, JD, CP, etc.
Hard = FT, TH, WK, MT, etc.

My data is entered across columns by date and down rows by employee. Does
anyone know how to sum the "soft" and "hard" events by row / employee?
Thanks.

 

[Ashish Mathur]

Hi,

Assume that your first employee data is in row 21 (Let's say the workevents
are in D21:I21). In C26:C31, enter the soft codes and in D2629, enter the
hard codes. In cell J21, enter the following formula to count the soft
codes

=SUMPRODUCT(1*(ISNUMBER(MATCH($D21:$I21,$C$26:$C$30,0))))

For hard codes

=SUMPRODUCT(1*(ISNUMBER(MATCH($D$21:$I$21,$D$26:$D$30,0))))

Hope this helps

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com