Posted to microsoft.public.excel.worksheet.functions

Barb Reinhardt Barb Reinhardt is offline

external usenet poster

Posts: 3,355

Sumproduct question

I have a bit of a complicated SUMPRODUCT question.

1) I want the year of row 3 to match the year of the named range
"CurrentMonth"
2) The row # for the second array is defined in B100 (for example)

Can someone assist?

KEep in mind that there are numeric and text values in row 3 as well as in
the dynamic row #.

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
sumproduct question	[email protected]	Excel Discussion (Misc queries)	5	November 8th 06 10:17 PM
A SUMPRODUCT question	Bernard Liengme	Excel Discussion (Misc queries)	3	October 17th 06 06:36 PM
Sumproduct Question	[email protected]	Excel Discussion (Misc queries)	9	March 10th 06 04:26 PM
Question about sumproduct	Jason	Excel Discussion (Misc queries)	1	April 21st 05 05:44 PM
Question about sumproduct	bj	Excel Discussion (Misc queries)	0	April 21st 05 05:40 PM

All times are GMT +1. The time now is 06:18 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us