Sum Cells from Costs Incurred in Weeks and Capture into Months / Years

[wesselsV]

Hi,

I've set up a budget for tasks in weeks. However, the cost ledger is prepared monthly and I am trying to capture my source data in weeks and arrange into budget for the month to enable analysis against WBS codes. On the attached I've used the MONTH and YEAR formula to convert my week ending date into a month and year and then run a sumif formula based on these against my WBS code but without success. Does the sumif formula not work with dates?


https://1drv.ms/x/s!As-9OWf6QipWg01qAWDto0t8j8Nv

Any help appreciated.

 

[Oscar Cronquist]

I am not sure what's wrong with your sumif function, however, the following SUMPRODUCT function seems to work:

=SUMPRODUCT($B$5:$S$16*($B$3:$S$3=B21)*($B$2:$S$2=B20)*($A$5:$A$16=A23))

 

[wesselsV]

I am not sure what's wrong with your sumif function, however, the following SUMPRODUCT function seems to work:

=SUMPRODUCT($B$5:$S$16*($B$3:$S$3=B21)*($B$2:$S$2=B20)*($A$5:$A$16=A23))

Perfect! Thank you