SUM IF/IFS question - reference multiple worksheets and multiple criteria

[Ken_Soona]

Hello everyone,

I am having trouble with a sum if/ifs formula. I have managed to get it to not throw an error, but it's not working correctly, and I know that b/c I have the data I want to sum, know what the summation should be, and it's not working.

I have weekly sales data in one sheet which I need to collapse into monthly data in another sheet.

Formula is copied into 12 cells, Jan - Dec, and is:

SUMIFS(
WeeklySheet!$D$24:$BC$24, ==#1
WeeklySheet!$D$15:$BC$15, ==#2
">=D10", ==#3
WeeklySheet!$D$15:$BC$15, ==#4
"<E10") ==#5

Where:
#1 is the row with the sales data, weekly
#2 is the row with dates, weekly
#3 is the on/after date, 1/1/2017
#4 is same as #2
#5 is the before date, 2/1/2017

In question form - I am asking:
"Hey Excel, be a pal, look through this row of sales data, and sum values for any cell whose date falls between 1/1/2017 and 2/1/2017."

For example, in the weeks in december of this year (4), predicted sales are 24, 27, 29, and 32 units, or 112 total. While I got the formula to not give me an error, it's not totaling up weekly sales for each week in the month.

Any help would be appreciated. Thank you very much.

[Ken_Soona]

Mods please delete entire thread. In my infinite wisdom I managed to post the same thread twice, and in both cases, I found an answer. Embarrassing way to do a first post on a forum that has been very helpful to me in the past. Sorry! Please delete entire thread.