look to see the type of device that was tested i.e "heat" and then count all
those and give me a number on the first sheet for that month.
Is the above a static list and the value is inserted beside the required
name or is the list dynamic and created as a unique values from the list that
is being counted?

--
Regards,

OssieMac


"steve s" wrote:

I'm trying to program excel to count up the number of devices on a sheet that
were tested during the month. I have a sheet that has devices in "a" column
i.e. heat pull water. I have another column that I populate after a device
was tested i.e column "I". A different sheet has cells for totals of said
devices that were tested that month. So, the program should look in column
"I" for an "X" showing tested, then look to see the type of device that was
tested i.e "heat" and then count all those and give me a number on the first
sheet for that month. There will be other devices of the same type that will
not have an "x" in the "I" column until next month, so I can't just add up
whatever is on the sheet.

Thanx

Steve S.