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.
Bookmarks