Avatar of pdvsa
pdvsa
Flag for United States of America 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
Microsoft Excel

Avatar of undefined
Last Comment
pdvsa

8/22/2022 - Mon
SOLUTION
Guy Hengel [angelIII / a3]

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
andrewssd3

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
pdvsa

ASKER
andrew:  that is pretty crafty.  It seems to work just fine.

Angell:  I do get an invalid outside procedure and the debugger highlights Sheet1 in the following line:
cols = Sheet1.UsedRange.Columns.Count

I am not certain how to use it though.  

thank you....
Guy Hengel [angelIII / a3]

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

ASKER
Thank you.  I ended up using the equation and this is why I split the points.   Any objections let me know...
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes