Hello all,

I was hoping for some support or a solution to a problem I've ran into. I have a billing sheet exported from a database. I currently have the following formula that works correctly.

=IF(J2="SD",IF(K2="IT",N2*38+38*0.25,(IF(K2="NT",N2*38,IF(K2="TO",0.25*22)))),IF(K2="IT",N2*43+43*0.25,(IF(K2="NT",N2*43,IF(K2="TO",0.25*22))))
)*O2

Think of the work as item, packing and delivery. This generates the correct cost for all work. My problem is that now we offer the following.

If a given project (I:I) is ordered on the same day (F:F) of the same profile (L:L) then packing and delivery only applies once and all additional orders have only delivery costs (N*22) assigned.

I have used the =COUNTIFS(I:I,I2,F:F,F2,L:L,L2) but this returns duplicate values of entries eg. 1 22 333 4444.

I don't know how to merge these correctly.

Thanks in advance. Your help is appreciated.