Extract and sum values from numerous worksheets from a particular date

**dwpcpa** · 09-27-2012, 11:54 AM

I have a number of worksheets which have values assigned to dates in the same row. The same dates and related values in the rows are not in consecutive rows and are found on multiple worksheets. I want to sum all the values from all of the worksheets from a particular date.
For example
I want the sum of everything done on September 27, 2012. The 8 worksheets have September 27, 2012 (41179) listed around 50 times in the same column on each worksheet. The values assigned to September 27, 2012 on each of these worksheets are also in the same column (not the same column as September 27, 2012. A different column than September 27, 2012 but in the same row as September 27, 2012, just to clarify).
I would like a formula that will look at the column with the date, in this case September 27, 2012 and add all the values from the same column in the same rows as September 27, 2012.
Anyone have a suggestion?

**fabasard** · 09-27-2012, 12:01 PM

I used the following to get VERY similar results, see if this works for you: It is the use of the SUMIFS condition.
I found my solution: Apparently the SUMIFS is quite handy. Used this little gem and got exactly what I needed:
=SUMIFS('Main Table'!$F:$F,'Main Table'!$I:$I,"=Scheduled Hours",'Main Table'!$D:$D,$K$6)
Here it is summing everything in column F (IF the corresponding row in I = Scheduled Hours AND column D = K6). K6 was a value that changes on a regular basis (it is the numeric value of the week of the year (so it could change from 1 to 52)). I appreciate the input from FDibbins, but wish I could have gotten more input from other people as well. I know this was not an easy problem. Thank you!