Posted to microsoft.public.excel.misc

Simon Minder Simon Minder is offline

external usenet poster

Posts: 16

counting

Hi all,

I have a counting issue. Let's assume the follwing data set:

Â¦ A Â¦ B Â¦
---------------------------
1Â¦ a Â¦ 2 Â¦
2Â¦ b Â¦ 1 Â¦
3Â¦ a Â¦ 5 Â¦
4Â¦ c Â¦ 2 Â¦
5Â¦ b Â¦ 2 Â¦

Result:
a 7
b 3
c 2

How can I get this done with a formula? I have tried with countif but it did
not work.

Kind regards,

Simon

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
counting function but not double counting duplicates	JRD	Excel Worksheet Functions	2	November 7th 07 06:43 PM
Counting	John	Excel Discussion (Misc queries)	3	August 15th 07 06:20 PM
Counting down	Bikertyke	Excel Worksheet Functions	5	December 6th 06 11:45 PM
Counting rows, then counting values.	Michael via OfficeKB.com	Excel Discussion (Misc queries)	7	August 4th 05 10:57 PM
Counting names in a column but counting duplicate names once	TBoe	Excel Discussion (Misc queries)	9	May 11th 05 11:24 PM

All times are GMT +1. The time now is 02:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us