Admit I'm surprised that you say this:
.. but it wasn't actually the answers i was looking for.

as your "additional" clarifications below seems to point back at the same
answers that you've received. I'm out of ideas to offer you.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"doyree" wrote in message
...
thank you kamil and max

but it wasn't actually the answers i was looking for.
i was looking for some formula that would

A B
apple dead
apple any condition
apple any condition
orange dead
orange any condition

then i wanted to build a condition that would give me
cell count of dead apples
cell count of live apples
and same for orange.
then i wanted to get the number for total live apples by
any condition - dead = live

hope i explained little better this time!!
please help!!

thanks!!!!