Bernard you have been so helpful I want to thank you. I was thinking that if
I showed you what I was working with and for it would help, so here is a
sample of what the data looks like:
A B C D E
Date Name Room success by
1-Nov john 1 y LR
2-Nov jane 1 y LR
2-Nov bill 1 y LR
2-Nov tony 1 y geo
3-Nov alfred 2 n/a geo
3-Nov horatio 2 n/a LR
5-Nov gene 2 n geo
6-Nov hillary 3 n LR
Here is what the table that I'm trying to auto update looks like. The
countif formula worked for the totals under Y, N and N/A, but I couldn't get
it to work properly for each persons individual subtotals
Attempts Y N N/A
LR
geo
Totals 0 4 1 2
Again Bernard thanks for your help so far.
"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).