Excel People, Calculation on Filtered Column

Reply Subscribe

Thread Tools

Search this Thread

Feb 18, 2008 | 07:30 PM

THORPEM

Thread Starter

Scooby Regular

Joined: Aug 2000

Posts: 282

Likes: 0

From: Hull

Excel People, Calculation on Filtered Column

Any Excel gurus, know how I perform a simple addition of all the values in a filtered Column =sum(x:y) is including the rows filtered out ..

Cheers

Last edited by THORPEM; Feb 19, 2008 at 11:53 PM. Reason: spelling

Feb 18, 2008 | 08:07 PM

bob269

Scooby Regular

Joined: Mar 2003

Posts: 2,654

Likes: 1

=SUBTOTAL(109,A1:A100)

Where A1:A100 would be your range

Feb 19, 2008 | 11:53 PM

THORPEM

Thread Starter

Scooby Regular

Joined: Aug 2000

Posts: 282

Likes: 0

From: Hull

thanks will try that

Reply Subscribe

Related Topics

Thread

Thread Starter

Forum

Replies

Last Post

2004 (54) Blue JDM Widetrack STi Fresh Import

KAS35RSTI

Subaru

Nov 4, 2021 07:12 PM

BUGEYE PRODRIVE STI BREAKING(rota's/racebox/whiteline/cusco/prodrive styling/6speed+

Mattybr5@MB Developments

Full Cars Breaking For Spares

Dec 28, 2015 11:07 PM

BUGEYE PRODRIVE STI BREAKING(bc br's/rota's/afterburner/6speed/ej207/brembos/prodrive

Mattybr5@MB Developments

Full Cars Breaking For Spares

Nov 18, 2015 07:03 AM

Subaru full forged 2.1 blobeye 468 bhp

Ganz1983

Subaru

Oct 2, 2015 09:22 AM

Misfire

IAN WR1

ScoobyNet General

Sep 28, 2015 08:14 PM

Reply Share

First
Prev
1 / 1
Next
Last

Forum Jump