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