Sumif between dates in different columns

Neil Spencer

Hi,

I have a sheet with the following columns "Resource required", "Shift", "Date From" and a "Date To".  What i need to do (Probably on another sheet) is sum the resource column against the criteria in the shift column and for a given date for the whole sheet.  Any ideas or help would be greatly appreciated.

Paul Newcome

Can you post some screenshots and a few examples of how you want the data displayed?

Neil Spencer

Hi Paul, Thanks for your offer of help but i managed to find a solution after doing some research. 

Paul Newcome

Excellent! Glad you were able to get something working.