asked on
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
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 5 Comments.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.