Thread
:
I would like to Count values in two columns.
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Roni
Posts: n/a
I would like to Count values in two columns.
When I do that, I get a "#Num!" error
=SUMPRODUCT(('Dr McNanley'!F:F="Grunert")*('Dr McNanley'!D:D="Vaginal"))
"Don Guillett" wrote:
try
=sumproduct((a2:a22="Dr Smith")*(b2:b22="procedure1"))
--
Don Guillett
SalesAid Software
"Roni" wrote in message
...
Hello - I am going INSANE for over a month now.... I need to figure out
how
to add up this information.
I have one column (Coulmn F) which list Doctors
I have another column (Column D) which list procedures
I need to count how many times each doctor did each type of procedure.
So I THINK I need to add up each occurance of "Dr.Smith" AND "Procedure 1"
Any help would be GREATLY Appreciated!!!! Thanks in advance!
Roni
Reply With Quote