Posted to microsoft.public.excel.programming

Norbert[_2_] Norbert[_2_] is offline

external usenet poster

Posts: 31

sumproduct problem

In column J I have stored different codes (numerical)
for each code a date is stored in column N
There can be more of the same codes in column J

I'd like to know how many times code "3" is found in column J,
whereby the associated date is greater than (date_no+17.5/24)

Can this be done?

Thanks
Norbert

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
sumproduct problem	[email protected]	Excel Worksheet Functions	6	December 12th 08 07:18 PM
sumproduct problem	nada	Excel Worksheet Functions	4	April 3rd 08 09:17 AM
sumproduct problem?	Tolga	Excel Discussion (Misc queries)	6	July 5th 06 05:27 PM
sumproduct problem	andy	New Users to Excel	2	March 29th 06 01:52 PM
Problem using sumproduct	Hiughs	Excel Worksheet Functions	4	March 5th 05 11:28 AM

All times are GMT +1. The time now is 06:32 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us