Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

Excel People, Calculation on Filtered Column

Thread Tools
 
Search this Thread
 
Old 18 February 2008, 07:30 PM
  #1  
THORPEM
Scooby Regular
Thread Starter
 
THORPEM's Avatar
 
Join Date: Aug 2000
Location: Hull
Posts: 282
Likes: 0
Received 0 Likes on 0 Posts
Default 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; 19 February 2008 at 11:53 PM. Reason: spelling
Old 18 February 2008, 08:07 PM
  #2  
bob269
Scooby Regular
 
bob269's Avatar
 
Join Date: Mar 2003
Posts: 2,654
Likes: 0
Received 1 Like on 1 Post
Default

=SUBTOTAL(109,A1:A100)

Where A1:A100 would be your range
Old 19 February 2008, 11:53 PM
  #3  
THORPEM
Scooby Regular
Thread Starter
 
THORPEM's Avatar
 
Join Date: Aug 2000
Location: Hull
Posts: 282
Likes: 0
Received 0 Likes on 0 Posts
Default

thanks will try that
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
KAS35RSTI
Subaru
27
04 November 2021 07:12 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
Ganz1983
Subaru
5
02 October 2015 09:22 AM
IAN WR1
ScoobyNet General
8
28 September 2015 08:14 PM



Quick Reply: Excel People, Calculation on Filtered Column



All times are GMT +1. The time now is 09:15 PM.