Thread: Formula help please
View Single Post
 
Old 12-08-2017, 12:14 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
Use SUMIFS()

Like
Code:
 
=SUMIFS(TheRangeOfBasePayOnSheet2, TheRangeOfCountryOnSheet2, CountryInRowOnSheet1, TheRangeOfJobCodeOnSheet2, JobCodeInRowOnSheet1)
Reply With Quote