Populating a cell with a BLANK value with another Non-BLANK value.

[Redwings19007]

I used the following formula to capture the sums for duplicate PO's where multiple items and various qtys were placed. However, the formula will only place a value on the last instance of the duplicate value.

=IF(B3,.B2, SUM($T$2:T2)_SUM($U$1:U1),"")

I need to have the full po value display on each line where the po is duplicated. Is there a way to either modify the above formula or another formula which will enable me to populate the previous lines with the full sum of the PO as well?

 

[Fazza]

what about if you change
the $T$2:T2 to T:T
and the $U$!:u1 to U:U