I am getting an error because the cells I want compared are in
non-consecutive rows. How can I work around this?

Thanks,
Eric
"Tom Ogilvy" wrote in message
...
=SUMPRODUCT(LARGE(C1:C500,ROW(1:100)))

--
Regards,
Tom Ogilvy


ZermaPersians wrote in message
...
I have a worksheet which I would like to sum the totals of the 100 cells
(same column, non-consecutive rows)
with the highest values in them and place this resultant in a cell of
its
own.

Can this be done?
Thanks,
Eric

P.S. I posted this in the MISC group the other day but I think this
group
may be more appropriate.