View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wind54Surfer Wind54Surfer is offline
external usenet poster
 
Posts: 16
Default How to get Countif to work this out?

Hi all,

I have as an example:

Columns
A B
apples----------------------2
oranges--------------------3
apples----------------------4
apples----------------------5
oranges--------------------3

How can I get the totals: apples=11 and oranges=6 using Countif

Any help is greatly appreciated,
Emilio