MATCH values on a subtotalled worksheet

[Vanessa Cassidy]

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

 

[Frank Kabel]

Hi
have a look at the SUBTOTAL function

 

[Vanessa Cassidy]

Thanks for your reply
Yes, this is my problem. I have used the SUBTOTAL function, and need to be
able to manipulate the data being returned from this function. Is it
possible ?

Thanks

 

[Frank Kabel]

Hi Vanessa
you may explain HOW you want to manipulate the data. I meant the
worksheet formula
=SUBTOTAL(...)
and not the function in the Data menu. So try to explain what you're
trying to achieve exactly