Hello,
I'm having problems with a sumifs function - could be something to do with the criteria for date syntax perhaps, summing total costs for each category of costs between 2 dates?
range to sum cost_data = Cost_data!$F$1.$F$1000
data range based on this cost data = Cost_data!$A$1.$A$1000
1st date criteria = Cost_data!$A$1.$A$1000,">=&$G$2" - date in cell $G$2
2nd date criteria = Cost_Data!$A$1.$A$1000,"<=&$G$3" - date in cell $G$3
3rd criteria = Cost_Data!$C$1.$C$1000,B14 - based on the value in cell B14 - category of costs.
Any help greatly appreciated!
Bookmarks