VLookup

I am trying to create a balance sheet (for payroll) where I can use a VLook up function to sum grand totals.

Example: I have 8 sections (at the top of my spreadsheet) where “Regular” time could be noted. I want my grand totals at the bottom of the spreadsheet to search each of the 8 sections, look for “Regular” hours/earnings, add them all together and give me a grand total.

I used a VLook up formula (SEE BELOW), but it is only pulling the first "Regular" field it finds, and I am unsure how to make it add all the "Regular" Fields together.

=IF(ISERROR(VLOOKUP($A$110,$A$4:$B$108,2,FALSE)),"",VLOOKUP($A$110,$A$4:$B$108,2,FALSE))

Spreadsheet attached.

Thanks!!!

How about:

Please Login or Register  to view this content.

Cheers,