Hi,
1. You need headers in database. For Example Fruits and Condition. So the
table should now looks like this:

A B
Fruit State
Apple DEAD
Apple LIVE
Apple DEAD
Orange DEAD
Orange LIVE
Peach DEAD
Peach DEAD
Peach LIVE

2. Then You should repeat the headers name for the fruits and list the
condition bellow them. For example like this:

A B C D E
Fruit State Fruit State
Apple DEAD Apple DEAD
Apple LIVE
Apple DEAD
Orange DEAD
Orange LIVE
Peach DEAD
Peach DEAD
Peach LIVE

3. In no mather which cell insert formula:

=DCOUNTA(A1:B9;B1;D1:E2)

That should work. Good luck!




"doyree" wrote:

i have following condition
please help!!!

Apple DEAD
Apple LIVE
Apple DEAD
Orange DEAD
Orange LIVE
Peach DEAD
Peach DEAD
Peach LIVE

how can i get a value for
# of dead apples, orange, and peach
# of live apples, orange and peach
not total but each individual value

thank you very much!!!!