Adding values based on date and Revenue Center

[rgillson3]

I'm trying to update a worksheet, and HATE continuously editing cells. ie. +5204.52+2345.61.

In my spreadsheet, I have the following sample data:

Week ending dates in D2:D5
Revenue Center names in E1:J1
Sales data in E2:J5

I have the same Revenue Center names in A2:A6, and a single date in B1.

My goal is to be able to change the date in B1, and have add the numbers from the Data field in E2:J5.

I want to a) pull Sales data for a single week and b) pull Sales data for year to date.

I'm trying to start with the formula: =SUMIFS($E$2:$J$5,$E$1:$J$1,$A2, $D$2:$D$5,B1)

I keep getting a #VALUE ! err, and can't figure out why.

I also thought a SUMPRODUCT formula might work, but don't know/understand the formula enough.

 

[SpillerBD]

=sumifs($e$2:$j$5,$e$1:$j$1,"="&$a2, $d$2:$d$5,"="&b1)