asked on # Sum rows if greater than X

Experts,

I have a spreadsheet with many columns and only 1 row of data

If the sum of the numbers is >=500 then combine those numbers and put the result in the cell.

Keep doing this until you reach the last column.

I am trying to avoid a manual process and increase my efficiency.

Right now, I have to manually look at the data and sum if >500.

The spreadsheet is a scaled down version.

maybe there is some canned function in excel for what I am after.

thank you.

sum500.xls

I have a spreadsheet with many columns and only 1 row of data

If the sum of the numbers is >=500 then combine those numbers and put the result in the cell.

Keep doing this until you reach the last column.

I am trying to avoid a manual process and increase my efficiency.

Right now, I have to manually look at the data and sum if >500.

The spreadsheet is a scaled down version.

maybe there is some canned function in excel for what I am after.

thank you.

sum500.xls

Microsoft Excel

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

you need to put the whole code inside a procedure...

Thank you. I ended up using the equation and this is why I split the points. Any objections let me know...

Angell: I do get an invalid outside procedure and the debugger highlights Sheet1 in the following line:

cols =

Sheet1.UsedRange.Columns.CountI am not certain how to use it though.

thank you....