I would be some empty cells in the range and yes, it will only be A and P and
the cells could be any number of digits, i.e, it could be 24A or 124A, 3P or
344P. I am trying to do a cumulative addition based on whether the cell value
ends in A or P and also adding all the previous cells.

"T. Valko" wrote:

G308=4A, H308=4P, I308=3A and J308=2P
take into account the As and Ps.

Do the cells *always* contain a single digit followed by a letter? Are there
any empty cells in the range? Are there any formulas in the range that
return formula blanks ("")?

--
Biff
Microsoft Excel MVP


"Ayo" wrote in message
...
I have the following: G308=4A, H308=4P, I308=3A and J308=2P and so on for
that row.
Now I want the following to happen: G338=4, H338=4, I338=7 (4+3, the
number
part of G308 and the number part of I308) and J338=6 (4+2, the number part
of
H308 and the number part of J308)
I got a formula that would do the additions for me, array-entered,

=$F5+SUM(IF(MOD(COLUMN($G$5:G$5),2)=MOD(COLUMN(G5) ,2),$G5:G5,0))

if I didn't have the As and Ps in row 308. But what I really need is
something similar that would take into account the As and Ps.

Any ideas. Thanks