MATCH values on a subtotalled worksheet
 

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

MATCH values on a subtotalled worksheet
 

Hi
have a look at the SUBTOTAL function

--
Regards
Frank Kabel
Frankfurt, Germany

"Vanessa Cassidy" schrieb im Newsbeitrag
...
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

MATCH values on a subtotalled worksheet
 

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" wrote in message
...
Hi
have a look at the SUBTOTAL function

--
Regards
Frank Kabel
Frankfurt, Germany

"Vanessa Cassidy" schrieb im Newsbeitrag
...
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

MATCH values on a subtotalled worksheet
 

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 :-)

--
Regards
Frank Kabel
Frankfurt, Germany

"Vanessa Cassidy" schrieb im Newsbeitrag
...
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" wrote in message
...
Hi
have a look at the SUBTOTAL function

--
Regards
Frank Kabel
Frankfurt, Germany

"Vanessa Cassidy" schrieb im Newsbeitrag
...
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