Adding figures within range if date criteria is met

**txt_mess** · 09-03-2010, 11:07 AM

Right so i have learned from my previous posts and have attached a sample file to show what I am trying to achieve.

Right I have been able to work out a formula ( that does work ) for counting the number of times something falls in the range

=SUMPRODUCT(('Open Requests'!B7:'Open Requests'!B212>=B9)*('Open Requests'!B7:'Open Requests'!B212<=C9))

But now I am trying to count/add the amount of items / volume ( no of items column ) if it falls in between that range and so far excel is not playing ball

Any ideas would be appreciated ,

Thanks Ciaran

**NBVC** · 09-03-2010, 11:48 AM

You need to add the summing range at the end..

e.g.

=SUMPRODUCT(('Open Requests'!$B$7:$B$212>=B9)*('Open Requests'!$B$7:$B$212<=C9),'Open Requests'!$G$7:$G$212)

Note: I added the $ to make the ranges absolute, so that you can copy the formula down and it won't change those ranges... only your B9 and C9 change as you copy down.

Adding figures within range if date criteria is met

LinkBack

Thread Tools

Rate This Thread

Display

Adding figures within range if date criteria is met

Re: Adding figures within range if date criteria is met

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions