Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Awkward autofilter question (URGENT!)
Hi Guys, hope someone can help with this its v awkward:
I Have a sheet which is on auto filter- example below filtered on name A b C Name Aux Duration 1 auxwk2 5 1 auxwk2 5 1 auxwk3 10 I use the following to count occourence's of the filtered aux code's. the formula is in 10 different cells identifying 10 different aux codes =SUMPRODUCT(SUBTOTAL(3,OFFSET($b$9:$b$9994,ROW($b$ 9:$b$9994)-MIN(ROW($b$9:$b$9994)),,1)), --($b$9:$b$9994="relevant aux code")) however i need to be able to also calculate the duration of the specific aux code within the visible cells. Eg: using table above the result i would be after is (code used refrencing 2 different aux codes in 2 cells): Cell 1(aux 2) - 10 cell 2(aux3) - 10 I know i have probably complicated the above more than necersary. Can anybody help at all? Kind regards Greeny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Awkward sumif/sumproduct with three criteria over two ranges | Excel Worksheet Functions | |||
autofilter-v.urgent | Excel Discussion (Misc queries) | |||
NEWSGROUP QUESTION URGENT | Excel Worksheet Functions | |||
Simple Question but need urgent help pls... | Excel Worksheet Functions | |||
validation question, urgent pls help | Excel Discussion (Misc queries) |