Could someone please help me with the below
The last part of the line I want to add the two cells together but it displays #N/A
=IFS($C1='Av Wage Cost'!C1,'Av Wage Cost'!C2+'Av Wage Cost'!C3)
Sheet attached for context, the formula is in C8
Also if any tips to rid my Div/0 error in AVERAGE lines would be welcome
Thank you
Try this in C8:
Is that what you're expecting?
Please Login or Register to view this content.
WBD
Office 365 on Windows 11, looking for ✶ rep!
Yes that works thank you, now I just need to understand it to amend for the rest of the row!
Actually, you can change it to this which will allow you to copy it across the sheet:
It's basically looking for the right week number and location on the Av Wage Cost sheet and summing the two values there. Would you recommend the Thai food in Meadowhall? :DPlease Login or Register to view this content.
WBD
Just saw your other request. Also, on a revisit to this sheet, it's more complex than necessary. See attached which implements some changes.
WBD
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks