• 100% Satisfaction Guarantee
Jason Jones, Computer Technician
Category: Microsoft Office
Satisfied Customers: 15826
Experience:  Over 10 years work experience.
30759776
Type Your Microsoft Office Question Here...
Jason Jones is online now

# In Excel 2010 - Would like to sum a row of numbers - say 1,

### Customer Question

In Excel 2010 - Would like to sum a row of numbers - say 1, 2, 3, >4 and get >10

Then multiply the cell with >10 by say 20 to get >200.

Is that possible?
Submitted: 4 years ago.
Category: Microsoft Office
Expert:  Jason Jones replied 4 years ago.

Jason :

Hello and thank you for your question today. My name is Jason. I look forward to helping you today.

Jason :

Anything is possible with Excel.

Jason :

In order to sum the row and multiply it by 20, you would use the following formula:
=SUM(A1:ZZ1)*20

Jason :

That would sum the A row and multiply it by 20.

Customer: replied 4 years ago.

Yes, agreed if it was just a set of numbers but you certainly won't get paid for such a simplistic answer.

The trick is to be able to cope with the > (greater than) sign - that is what I can seem to work out & will pay for - see my example.

DL

Expert:  Jason Jones replied 4 years ago.

Okay.

You did not specify that it would have the greater than sign. I assumed that the use of the > sign was an error on your part.

Please, give me 3 examples of what you are looking for.

Thank you.
Customer: replied 4 years ago.

No, the > is the sticking point - otherwise I would need an expert!!

refer to the original question - you will see there are two greater than signs - hardly a typo twice.

6, 12, >14, 34, >250, 12 when summed = >328

9, 37, >34, 18 when summed = >98

What I'm looking for is a similar Function in Excel to the ABS command - it will ignore sign (+/-) of a number when it is used in formulas.

Just need a Function that ignores the > and then if present puts it back at the end.

DL

Expert:  Jason Jones replied 4 years ago.
Thank you.

In this case, you will need a vba function written.

Can you give me more information on how you wish to implement this?

Will this function always look in the same row or will it be different?
Customer: replied 4 years ago.

Yes it will be applied to a number of columns in the same row.

Expert:  Jason Jones replied 4 years ago.
Thank you for the update David.

It did require a routine to be written.

Here is the example document that I have to show you:

After you open the document, be sure to enable Macros.

When you press the button, it will sum the first row as you described.

You can edit the Macro by clicking the Developer tab, clicking Visual Basic, then double clicking the Module that it is in.

If you have any questions, please, let me know.