Microsoft Office

Microsoft Office Questions? Ask a IT Expert for Support ASAP

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

Anything is possible with Excel.

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

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

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

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.

Examples in addition to the one already provided are

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.

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