I need a formula to sum values in the same column on multiple sheets
if it finds a specified value in the same row of a different column.
SUMIF works fine if I select a single sheet but as soon as I select
multiple sheets it errors and returns #VALUE