sum if last cell equals max row length

R

Rico

I have 47 rows with many gaps between filled cells.
Each week another column is added and some cells in that column will b
filled.
I have this formula in column J
=IF(COUNTIF(K12:IV12,"<>")<1,"",VLOOKUP(INT(lastinrow(K12:IV12)),Averages!$A$10:$V$30,MATCH(I12,Averages!$A$9:$V$9,0),FALSE))

How do I adjust this formula so that it will not return a value if th
lastinrow (or rightmost filled cell) is not in the last column in th
range. That is, the last column that contains filled cells.

The range that is being filled is K3:IV47 and row 2 has the date adde
along the row. The most recent date is the column I want for th
calculation.

I have been trying to get the and function to work but it is eludin
me.

Thanks in anticipation
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate last 4 data points in a column (with sometimes blank rows) 7
Problem with formula for finding last greater than/less than or equal to value 2
Formating a row based on one cell's date 3
*Issue* Concatenate dates in a large range of cells in a row. 5
Looking for the value that indicates last row number that has filled cells 5
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
Populating Row with dates 1
VLookup IF word in string exists within cell, use the word. 0

Top