filter logic

  • Thread starter Thread starter abarwinski
  • Start date Start date
A

abarwinski

Hi,

Here is my problem. I have a few filters in my sheet.
I want to make calculations within ranges what is in the filter, not
all data.
The formulas should be automatics, only recognize present filters
selection.
I am not a programmer, Can someone help me with
 
Hi,
Thanks for advice Ron,
I better describe my case.
This is perheps very simple solution but I'm not excel expert.
In my worksheet I am doing efficiency calculation.
I have names, products, work stations, hours, So can do that with
formulas.
I like to use filters for criteria selections and here is my stop.
I can write formulas to calculate sums, efficiency in unfiltered list
with no problem.
When I select criteria with filter I want sum, efficiency, etc.
calculations to be done regarding present filtered data only in
(automatics way).
Can I do that?
Adam
 
Take a look at =subtotal() in excel's help.

It supports 11 different functions.

AVERAGE
COUNT
COUNTA
MAX
MIN
PRODUCT
STDEV
STDEVP
SUM
VAR
VARP

So depending on what you wanted to do, you may be set.
 
Hi Guy's,

Thank you very much for help, this solved my problems
in general easy, but thanks to your knowledge and experience
what I'm lacking with excel.
Keep up friends,
Ada
 
Back
Top