Posted to microsoft.public.excel.worksheet.functions

Yamorna

external usenet poster

Posts: 5

The Count Function

Can someone please tell me if the following is poosible;

Date Fruit Consumed

01/03/09 Apple
01/03/09 Banana
01/03/09 Pear
02/03/09 Apple
03/03/09 Banana
03/03/09 Pear

I need a function that can tell me how many apples were consumed on
01/03/09, how many bananas on 01/03/09 and how many pears on 01/03/09. The
same for 02/03/09 and 03/03/09.

Hope someone can help.

Yamorna

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
Count function	Jerry Edge	Excel Worksheet Functions	3	February 15th 09 04:51 AM
count function further	AJ Patel[_2_]	Excel Worksheet Functions	5	March 12th 08 01:23 AM
Another which count function?	Johnny1r	Excel Worksheet Functions	7	February 24th 08 03:52 AM
WHICH COUNT FUNCTION?	Johnny1r	Excel Worksheet Functions	5	February 23rd 08 09:13 PM
using the count function	barklek	Excel Discussion (Misc queries)	3	August 22nd 05 01:00 PM

All times are GMT +1. The time now is 01:46 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us