Thread: How to get Countif to work this out?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Per Erik Midtrød[_2_] Per Erik Midtrød[_2_] is offline
external usenet poster
  
Posts: 25
Default How to get Countif to work this out?
On Sep 15, 6:12 pm, Wind54Surfer
wrote:
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

Use sumif instead of countif:
=SUMIF(A:A;"apples";B:B)

Per Erik


Reply With QuoteReply With Quote