conditional sum with date

cole.hitchcox cole.hitchcox is offline

New Member

Join Date: Nov 2010

Posts: 2

2nd Nov 2010

I have a feeling this is relativly simple, but I am having some trouble figuring it out. I have a workbook that contains several sheets of data that is linked to my SQL database. and I am trying to create a summary sheet that ties everything together in a readable format. I would like to divide everything up by week. so, what I need to be able to do is to construct a formula that would take SUM(Invoice!AB:AB)IF(Invoice!(daterange which the date is in column AG). Everthing after the IF is what I am not sure how to write. Any help on this matter would be appreciated.

Thanks!

« ROMANTIC SHOW | If and value between two numbers »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PLEASE HELP! need conditional formatting related to date, blank cellsand today's date	Michelle	Microsoft Excel Discussion	16	29th Mar 2011 02:57 AM
conditional formatte date in a1 calculate the date in A2	jcurran1ma	Microsoft Excel Worksheet Functions	3	1st Jul 2009 06:59 AM
Conditional Formatting - the date is between date A and date B	=?Utf-8?B?Tmlra2k=?=	Microsoft Excel Discussion	2	17th Sep 2007 02:22 AM
conditional formatting for date field - text or date	=?Utf-8?B?dHJldmk=?=	Microsoft Access Form Coding	2	26th Jan 2007 09:37 PM
conditional formatting for cell date to equal today's date	=?Utf-8?B?U2lzdGVyZWluc3RlaW4=?=	Microsoft Excel Worksheet Functions	1	14th Nov 2006 09:24 PM