Hi, I am looking to see why the formula below is returning a #Value response in the cell.
I am basically trying to sum a cost column based on 2 criteria-- 1- Date & 2- name of company.
If you see something missing from the formula I would appreciate a fix.
=SUMIFS('Planned-Manpower Cost'!YF$9:YF$142,'Planned-Manpower Cost'!$B$9:$B$142,'Summary- Roll Up'!$B5,'Planned-Manpower Cost'!$YF$5:$AYO$5,'Summary- Roll Up'!C$2)
I am basically trying to sum a cost column based on 2 criteria-- 1- Date & 2- name of company.
If you see something missing from the formula I would appreciate a fix.
=SUMIFS('Planned-Manpower Cost'!YF$9:YF$142,'Planned-Manpower Cost'!$B$9:$B$142,'Summary- Roll Up'!$B5,'Planned-Manpower Cost'!$YF$5:$AYO$5,'Summary- Roll Up'!C$2)