This description is far different from your OP!
You should make a unique list of your clients, say from N2 down to N26 (25
clients),
Matching *exactly* with the entries in Column B.
In N1, you'll enter the day you wish to examine (poll).
This N1 entry *must* match the format that you're using in Column A,
Whether it's a simple number depicting the day, or if you're using a real
date format.
In O1 to R1 you'll enter your service codes.
Needles to say, these entries must match *exactly* with the codes in Columns
G, J, and M.
Enter this formula in O2 and copy across to R2,
Then copy the O2:R2 range down to the row of your last client name.
=SUMPRODUCT(($A$1:$A$1000=$N$1)*($B$1:$B$1000=$N2) *($G$1:$M$1000=O$1))
This formula assumes there are *no* service code data values in Columns H,
I, K, and L.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"RayH" wrote in message
...
I thought the formula would be easier to understand and transpose to my
actual spreadsheet. But I understand that the principle of what I am
trying to extrapolate can be done.
What I am trying to do is to track the services for clients on a daily
basis. We will change sheets monthly. We deal with 15-25 clients
daily, each of whom may use 1-3 of four services.
In the actual sheet, Column A is the date, as represented by a two
digit number for the day of the month: 01-31.
Column B has the client name. Columns G, J, and M list the shifts
(Morning, Afternoon, Afterhours). Clients might receive services coded
as C, 36, MH, and NB. Any of these four codes can be entered in G, J,
M.
So on each day I'll have one row for each client or about 15-25 rows of
information in columns g, j, and m I want to be able to track. (c, 36,
mh, and nb)
--
RayH
------------------------------------------------------------------------
RayH's Profile:
http://www.excelforum.com/member.php...o&userid=36647
View this thread: http://www.excelforum.com/showthread...hreadid=564005