Roger Govier

Posts: n/a

Hi Dawn

Try
=SUMIF(A7:A15,"=12/04/05",B7:B15)-SUMIF(A7:A15,"14/04/05",B7:B15)

Regards

Roger Govier

dawn wrote:
=SUMIF(A7:A100,"=12/04/05-<=14/04/05",B7:B15) what am i doing wrong

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
count date occurances in range of dates...	Alex	Excel Worksheet Functions	2	July 27th 05 04:15 PM
Update cell based on date range	deversole	Excel Discussion (Misc queries)	3	July 6th 05 01:58 PM
adding occurrences for date range	Mike	Excel Discussion (Misc queries)	0	April 8th 05 11:33 PM
Change the low date range regional setting.	genesearcher	Excel Discussion (Misc queries)	1	March 17th 05 06:51 PM
SUMPRODUCT with date range question	Rob V	Excel Discussion (Misc queries)	1	January 31st 05 03:55 PM

All times are GMT +1. The time now is 10:16 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us