Typo

=SUMPRODUCT(ROW(INDIRECT("4:10"))*2.43)+SUMPRODUCT (ROW(INDIRECT("11:"&A1)))*1.75

--
__________________________________
HTH

Bob

"Bob Phillips" wrote in message
...
=SUMPRODUCT(ROW(INDIRECT("4:10"))*2.73)+SUMPRODUCT (ROW(INDIRECT("11:"&A1)))*1.75

--
__________________________________
HTH

Bob

"LindaM" wrote in message
...
I am trying to write a formula that will multiple the numbers between 4
and
10 by $2.43 and add that to the numbers between 11 and 100 that is
multiplied
by $1.75.
Example: A1 = 61 and the total in B1 would be 4 thru 10 multilplied by
2.43
and then added to 11 thru 61 that has been multiplied by 1.75
--
LindaM