Hi All,
Is their anyone here that can help me figure out the best way to formulate a value in my spreadsheet?

I need a way of reading all values across a range (specified by date columns) up until the LAST populated cell thats greater than 0/NOT blank. And then identifiing any values within that closed range that are LESS than $value.

I've thought about using some form of date value firstly to identify the closest date to 'TODAY' and then working the cell values backwards from there.

I hope this makes some sense...

Thanks for reading,
Ollie

I have created programs for engineering using Excel that calculate snow drift loads and unbalanced loads for steeples on roofs. I will work on your issue for a while and see what I can come up with for you. If I need more info. I will simply pm you.

__________________
Hello I am one of you CompuForums moderators. Please feel free to drop me a pm if you have any questions or problems with another member. My specialty is civil engineering. However I can assist you, I will always do my very best.

What version of Excel are you running?

In your spreadsheet there is a Function tool. In the Functions menu, select More Functions, and then select Lookup & Reference. There you'll find the functions you need to incorporate into you range.

Posting an example or screenshot of the range would be benificial to all.

Yo!

thanks mud_afuka
The range looks like this:

N2 O2 P2 Q2 R2 S2
01 February 2008 Interest Balance 08 February 2008 Interest Balance


What I need is a sum of all the values under the 'date' columns up to TODAY(). The range above continues for a whole year.

I started a formula that looks like this:
=SUM(IF(N2:FN2<=TODAY(),N8:FN8,0)) but it takes ALL the data from every column in the row, not just the date columns.

Thanks, Ollie

Select all data and use IF x > z, THEN y. There is a function to incorporate SUM using IF/THEN with > and <.

Yo!