filter logic

[abarwinski]

Hi,

Here is my problem. I have a filter in my sheet.
I want to make calculations within range what is in the filter, not all data.
The formulas should be automatics, only recognize present filter selection.
I am not a programmer, Can someone help me with

[Ron de Bruin]

Maybe you are looking for the Subtotal functions
Look in the Excel help

--
Regards Ron de Bruin
http://www.rondebruin.nl


"abarwinski" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>
>
> --
> abarwinski
> ------------------------------------------------------------------------
> abarwinski's Profile: http://www.excelforum.com/member.php...o&userid=27320
> View this thread: http://www.excelforum.com/showthread...hreadid=468458
>

[abarwinski]

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

[Dave Peterson]

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.

abarwinski wrote:
>
> 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
>
> --
> abarwinski
> ------------------------------------------------------------------------
> abarwinski's Profile: http://www.excelforum.com/member.php...o&userid=27320
> View this thread: http://www.excelforum.com/showthread...hreadid=468458

--

Dave Peterson

[Ron de Bruin]

Same answer

Look here
http://www.contextures.com/xlFunctions01.html#Filter


--
Regards Ron de Bruin
http://www.rondebruin.nl


"abarwinski" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>
>
> --
> abarwinski
> ------------------------------------------------------------------------
> abarwinski's Profile: http://www.excelforum.com/member.php...o&userid=27320
> View this thread: http://www.excelforum.com/showthread...hreadid=468458
>

[abarwinski]

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,
Adam