conditional sum with date

C

cole.hitchcox

Joined
Nov 1, 2010
Messages
2
Reaction score
0
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

[CSE] SUM Array Formula with if condition 1
Conditional Sum? 2
Changing Sum Range Based on Date Chosen from Drop Down List 1
Auto Change Formulas - Please Help. 2
Conditional formatting with multiple formula 2
Blank date column return datel 00-Jan-00 4
Conditional sum wizard 1
Conditional sum equals 0 4

Top