Posted to microsoft.public.excel.misc

Cita

external usenet poster

Posts: 12

Is this possible? SUMPRODUCT with criteria range?

Hello again-
I have the following categories:
(TIME) 12/31/2007 1/1/2008 1/2/2008
A 0800 1959
B 2000 0759
C 0000 1159
D 1200 2359
E 0700 1900
F 1900 0700

I also have 2 columns, 1 has a date and 1 the time. I want to count how many
records meet the (1) date criteria and (2) fall within the time range...is
this possible? I've used SUMPRODUCT before but never with a conditional like
this.

Thanks!

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
RANGE EXCEL copy cell that meets criteria in a range	confused	Excel Worksheet Functions	3	March 27th 08 01:41 PM
Sumproduct 4 criteria	Laura	Excel Worksheet Functions	0	November 29th 06 11:02 PM
Sumproduct-multiple criteria for same range "OR"	Deeds	Excel Worksheet Functions	3	May 18th 06 04:43 PM
Find dates in a range; then sum values in that range by a criteria	Anders	Excel Discussion (Misc queries)	4	October 21st 05 03:41 PM
Dynamic range names, multiple criteria, sumproduct	[email protected]	Excel Discussion (Misc queries)	1	September 20th 05 02:58 AM

All times are GMT +1. The time now is 09:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us