Try the following array formula...
=SUM(IF(ISNUMBER(A1:G13),A1:G13*1.2))
....confirmed with CONTROL+SHIFT+ENTER.
Hope this helps!
In article ,
"Jim" wrote:
How can I find all cells in a sheet that are a number
greater than zero and multiply each one by a number?
IE: the number to multiply by is 1.2
A1 Tom
A2 25
A3 0
G12 Bob
G13 25
I want to programatically (without using a macro) find
cells a2 and g13 only and multiply them by 1.2
Thanks in advance for your help.
Jim
|