Hi,

I have created a spreadsheet with numbered values in cells. At the top of
the spreadsheet I have an area for calculations. Within the spreadsheet I
have several repeated lines of text with numbers tied to them. I thought
that when I filtered the spreadsheet for a certain lineof text or name, the
appropriate calculations would be performed only on/for that line of text or
name. This is not happening as Excel is making calculations from the entire
sheet. Is it possible to have Excel filter for a certain line of text, there
may be 200 entries or so and calculate only what is being filtered. I can
group these to avoid the problem, but then the spreadsheet is added to daily
with numerous other lines of text or names and that would not be feasable. I
need to filter for a certain line of text or name and have Excel calculate
only those values tied to it and not the entire sheet. Is this possible?

Thanks for any help in advance!!