Posted to microsoft.public.excel.worksheet.functions
|
|
Create a function to add one to the count
SUMPRODUCT ?
--
David Biddulph
"Lawrence" wrote in message
...
now on the downside............ apparently COUNTIFS(excel2007-home
version)
isn't compatible with excel2003 (work version). wonder if I can talk the
IS
guys into getting 2007. OR is there some compatible function in 2003?
"Lawrence" wrote:
Bernard, you got me looking in the right direction. I found that using
=COUNTIFS(D2:D9,"=*",E2:E9,"=lr") and variations using Y N & N/A as well
as
lr & geo will break out the individual subtotals that I want. Thanks so
much
for your help in pointing me in the right direction.
"Lawrence" wrote:
OHHH I forgot to let you know, at work I have Excel 2003
"Bernard Liengme" wrote:
=COUNTIF(D2:D22,"Y")
This is not case sensitive so it counts Y and y
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"Lawrence" wrote in message
...
initially that would have worked but there are two people that can
put
either
Y, N, or n/a (if we do not attempt at all) in the D column.
"Bernard Liengme" wrote:
Have you tried using =SUM(D2:D22) where D2:D22 is the range of the
numbers
to be added together (summed)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"Lawrence" wrote in message
...
OK, this is probably an easy one, but I can't figure it out. We
(two of
us)
keep a list of patients that we put PICCs in, I want to have a
small
table
automatically total the number Attempts, not attempts, and
successful
placements.
so basically, if D3=Y and E3=LR then add one to the number in
Attempts
(J4)
and successful placements (J6).
|