Thanks for the help. Works great.



Lars-?ke Aspelin wrote:

Assuming that your data are on row 2 and that the cell next to thedata you
31-Dec-09

Assuming that your data are on row 2 and that the cell next to the
data you want to sum is blank, try this formula:

=SUM(OFFSET(A2,,MIN(IF(ISBLANK(A2:IV2),COLUMN(A:IV )))-13,,12))

Note: This is an array formula that has to be confirmed by
CTRL+SHIFT+ENTER rather than just ENTER.

Hope this helps / Lars-?ke

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
ASP.NET DropDown ListBox and XML Databinding
http://www.eggheadcafe.com/tutorials...n-listbox.aspx