LOU

Posts: n/a

SUMIF or SUMNPRODUCT Help

Hello!

how do I write this one?

B1 thru B300 has date values
F1 thru F300 has the dollar values

I need a formula to sum them up by date range using the between or <..
SUMIF(B1:B300,"BETWEEN 10/01/2004 AND 11/01/2004", F1:F300) ?????
SUMPRODUCT..?
HELP.
Thank you.

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
SUMIF Criteria	Brent Martin	Excel Discussion (Misc queries)	6	January 7th 05 05:17 AM
SumIF	anuita	Excel Discussion (Misc queries)	1	January 4th 05 06:06 PM
SUMIF with only one criteria cell within range	Stan	Excel Discussion (Misc queries)	5	December 16th 04 10:12 PM
creiteria in sumif	Frank Kabel	New Users to Excel	3	December 16th 04 07:23 AM
sumif 2 criteria	Doug	Excel Worksheet Functions	1	October 27th 04 05:06 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us