Posted to microsoft.public.excel.worksheet.functions

opal

external usenet poster

Posts: 7

count if using columns not range of cells

Hi,
Im trying to generate a count that will tell me how many of 'x' are in
column B only if column A's data are within a date range eg for the month of
June.

A B
16-Jun-08 Apple
16-Jun-08 Pear
30-May-08 Apple
18-Jun-08 Orange
16-Jun-08 Apple
12-Apr-08 Pear

Thanks
--
Opal

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 Certain Cells in Specified Range	Xavier	Excel Worksheet Functions	3	July 25th 06 10:25 PM
count cells in a range	fullers	Excel Worksheet Functions	2	November 30th 05 01:36 PM
count all the columns in a range with certain conditions	hopeace	Excel Discussion (Misc queries)	3	October 18th 05 08:38 PM
Count occurances in range of cells	Ed Gregory	Excel Worksheet Functions	1	September 7th 05 04:12 PM
Count cells in one range based on parameters in another range	dave roth	Excel Worksheet Functions	2	March 29th 05 05:33 PM

All times are GMT +1. The time now is 04:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us