shmurphing

Posts: n/a

complex formula

I asked about a formula and I have one more question.

I have composed the following formula
=SUMPRODUCT(--('Wpg #s data'!C6:C500="One"),--('Wpg #s
data'!J6:J500DATE(2004,12,1)))

But instead of specifying a date, I want to use a cell reference. I I had
the cell of J4 as the date to use, how would the formula look?

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
revert formula insertion to old method	Don't be a pain in the ass	Setting up and Configuration of Excel	0	January 24th 05 01:49 PM
Simple formula doesn't quite add up	circeo	Excel Discussion (Misc queries)	3	January 17th 05 09:04 PM
complex formula	shmurphing	Excel Worksheet Functions	6	December 21st 04 03:57 AM
Cell doesn't show formula result - it shows formula (CTRL + ' doe.	o0o0o0o	Excel Worksheet Functions	6	November 19th 04 03:13 PM
Complex formula help needed	Jan	Excel Worksheet Functions	0	November 9th 04 03:19 PM

All times are GMT +1. The time now is 05:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us