Please see attachment.
I have a formula =SUM(IF($E$3:$E$600<=H8,$D$3:$D$600,0)) and the objective is to total the monthly salaries based on the month that they were hired. I keep having amounts come up in the incorrect month.
TIA,
ExcelNewby
Please see attachment.
I have a formula =SUM(IF($E$3:$E$600<=H8,$D$3:$D$600,0)) and the objective is to total the monthly salaries based on the month that they were hired. I keep having amounts come up in the incorrect month.
TIA,
ExcelNewby
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks