pdvsa

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

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

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

ASKER

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

ASKER

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....