LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 7
Default counting the last 3 values not equal to x in a list

ok, im in desperate need of help...

i have 20 columns (cells A1 to T1) in these cells the default value is 'x' but these x's change to numerical values when i enter data elsewhere. leaving me with a possible example like this...

12 4 4 11 7 1 1 19 20 6 13 x x x x x x x x x

i want to be able to add up the sum of the last THREE values (on the rightmost side) that arent equal to x

i.e. i want to add 20, 6 and 13

however the position of these last three values can vary between anywhere in these columns although they are always joined (never an x between two values but can be in columns A,B,C or G,H,I or R,S,T)

and i cant change the order the numbers appear.

anyideas what i could enter into cell U1???

Last edited by bouncebackability : April 9th 08 at 06:18 PM
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting unique values in a list generated with the OFFSET functio mikelee101 Excel Worksheet Functions 3 December 6th 07 09:50 PM
counting the number of equal rows Malte Lindner New Users to Excel 1 April 15th 06 09:48 PM
Counting the number of values in a list between two specified valu andyuae Excel Worksheet Functions 2 November 25th 05 03:32 PM
How to add equal values and than replace them with their sum? Sergiy G. Excel Worksheet Functions 0 September 7th 05 01:06 AM
list values equal in 2 worksheets? NEVA LOCKETT Excel Worksheet Functions 2 February 23rd 05 03:21 PM


All times are GMT +1. The time now is 04:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"