Feb 20, 2009
I've got a very large spreadsheet wherein I need to write a formula for each row to find the first cell with any entry greater than 0 and then add to that cell the contents ONLY 5 cells contiguious to it.
View 9 Replies
For example data set is this (in .csv format for you)
Name, Jan01, Feb01, March01, April01, May01, June01, July01, Aug01, Sept01, Oct01, Nov01, Dec01, Jan02, Feb02, March02, April02, May02
I need formula to find first instance in each row of entry greater than 0 and then add to that the contents of next 5 cells.
Jones would find the 5 and then add the 2,7,9,3,10 to it for formula result of 36
Smith would find the 3 and then add the 8,17,23,9,3 to it for formual result of 63