LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Dave O
 
Posts: n/a
Default

Using the sample data you provided- headers in row 1 from column A ~ I
and the criterion and data in A2:I13, I got a solution by adding two
elements. The first is a total column, J, that sums your data in
advance. The next is a max age number in cell B13: it was easier to
add the max age of 999 rather than figure out a solution that left that
cell blank. By using 999 you are effectively providing an unlimited
ceiling age, but still one the formula logic can work with.

If you'll enter your target age in cell A16, enter this formula in B16:
=SUMPRODUCT(--(A16=$A$2:$A$13),--(A16<=$B$2:$B$13),$J$2:$J$13)

The formula checks your indicated age to see where it fits in the grid,
and returns the total from column J.

 
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
Formula works in some cells, doesn't in other Wowbagger New Users to Excel 13 June 30th 05 03:21 PM
Modify SumIF... Array Formula carl Excel Worksheet Functions 2 May 17th 05 07:52 PM
IF & VLOOKUP FORMULA taxmom Excel Worksheet Functions 3 March 2nd 05 03:35 PM
Relative Indirect Formula Referencing? Damian Excel Worksheet Functions 1 January 7th 05 04:16 AM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 03:13 PM


All times are GMT +1. The time now is 05:49 PM.

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"