HI

Here is what i attempted:

=SUM(COUNTIFS('QREC Manage Job Requisitions |I'!N:N,{"2","3H","3L","4",'QREC Manage Job Requisitions |I'!W:W)

Essentially if there is anything in column n that matches 2,3h,3L or 4 then I would like all the numbers in column W counted up for a total...

Ive spent around 2 hrs believe it or not and was so pleased when i was able to count the N column only...

But alas I would appreciate any help

Izzy