Hi

I have 2 worksheets; one of which is made up of subtotals. I want to cross
check these subtotals with values in another worksheet. I have tried the
MATCH functions and nested IF statements, however, it is including all the
data which makes up the subtotals in the calculations. I only require the
actual totals themselves, as these match 1:1 with the second worksheet.

can any one help ?

Thanks