Count If formula
I got help yesterday and hopefully can today.
I now need a formula to count the number of "n/a" by each person. ER MD WAIT TIME TO SEE PHYSICIAN smith n/a harris 0:21 david n/a david 0:43 smith 0:25 harris 0:18 harris n/a Again, this is the same sheet and has about 2500 entries for one month. I need to find out what physicians had a wait time of "n/a" without having to sort the entire sheet by physician. Thanks. |
For Smith
=SUMPRODUCT(--(A2:A2500="Smith"),--(B2:B2500="n/a")) replace Smith with a cell where you put the different names for better usability Regards, Peo Sjoblom "Denise" wrote: I got help yesterday and hopefully can today. I now need a formula to count the number of "n/a" by each person. ER MD WAIT TIME TO SEE PHYSICIAN smith n/a harris 0:21 david n/a david 0:43 smith 0:25 harris 0:18 harris n/a Again, this is the same sheet and has about 2500 entries for one month. I need to find out what physicians had a wait time of "n/a" without having to sort the entire sheet by physician. Thanks. |
All times are GMT +1. The time now is 11:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com