Keep certain cells from moving

G

guilbj2

I'm sure this will be an easy one, but I can't seem to find the info i
help. I'm using Excel 97 and have a simple sheet with a few columns o
data. I've setup auto-filters for colums A-E.

What I want to to is put some formulas in column F that don't ge
blanked out when I use the filters (if they're on a line that doesn'
meet the condition I've selected, they dissappear). I'd also like the
to give me dynamic totals.

For instance, I have dollar amounts attributed to certain people in on
column and their names in another. If I use the filter to select onl
the records for one name, I would like the formula to show me the tota
for the dollar amount column, based on the filtered results.

Could someone let me know what type of formulas/formatting I need t
get this working
 
G

guilbj2

That works perfectly for the formula, but what do I do about losing th
formula when the wrong row is filtered out ?

Say I put the formula in F22. I apply the filter, but the conditio
I've set doesn't exist in row 22 for whatever colum I've filtered.
That row, along with the formula, gets hidden. Is there any way I ca
freeze the formula in place so that it's not affected by the row
hidden by the auto-filter
 
Top