|
|
#6
12-08-2017, 12:14 AM
|
|||
|
|||
Use SUMIFS()
Like Code:
=SUMIFS(TheRangeOfBasePayOnSheet2, TheRangeOfCountryOnSheet2, CountryInRowOnSheet1, TheRangeOfJobCodeOnSheet2, JobCodeInRowOnSheet1) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| IF(OR - IF(AND // Formula Help | Pixie | Excel | 2 | 09-06-2017 11:12 PM |
 Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula
|
innkeeper9 | Excel | 2 | 09-13-2016 08:59 PM |
|
if(and.. formula
|
paxon | Excel | 8 | 05-19-2016 08:05 AM |
| Need help with dragging a formula and changing a reference column as I drag the formula. | LupeB | Excel | 1 | 10-22-2015 03:02 PM |
|
Formula Help
|
odonnest | Excel Programming | 8 | 01-23-2015 07:18 AM |
Windows 8 
Office 2016
Threaded Mode