Cross sheet sum if
I'm creating a sheet to record the use of agency/contracting staff across a site (once the proof of concept is done it'll be expanded to cover multiple sites), where entries will be added to the sheet below via form. The "within budget" column on the 1st sheet should be picking up any entry from the Month Total Spend (MTD) col on the second sheet where the Year and Month column match on both sheets. The formula is below:
=SUMIFS({Sheet - Unit 1 Agency Budget Alert Range 2}, {Sheet - Unit 1 Agency Budget Alert Range 1}, =Month2, {Sheet - Unit 1 Agency Budget Alert Range 3}, =Year2)
Any thoughts much appreciated!
Comments
-
Everything looks in order, but I can't say for sure unless you can provide some screenshots or more details on the layouts of your sheets. Is your formula not working?
Help Article Resources
Categories
Check out the Formula Handbook template!