View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
doyree doyree is offline
external usenet poster
 
Posts: 24
Default please help with dcounta

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!!!!