Re: reference a range based on a cell value

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On a separate *** just input in A1

=IF(Sheet1!A1<>"",SUM(Sheet1!A:A),"")

and drag across as far as you are likely to ever need.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"william kossack" <wskossack@xxxxxxxxxxx> wrote in message
news:kbSdnXOOCavPXpbbnZ2dnUVZ_rWnnZ2d@xxxxxxxxxxxxxx
I have a *** where row 1 has names and the rest of the columns numbers.

for example
harry, bill, ann, kathy, and sparky

A program that I can not change pushes data into the spread***. I'd
like to be able to calculate row totals for defined groups of names.

one day the columns might contain
harry, bill, ann, kathy and sparky
but the next day it might contain
harry, sam, bill, sparky, ken

The problem is as the list of names changes columns get added or taken out
of the ***.

How can I set up formulas to compute the sum of rows for say
harry, bill, and sparky without having to redo the formulas each time?


.

Quantcast