Hey peoples, I have a very in depth massive workbook that stores information for orders. I am trying to make a formula that calculates totals based on if an "Order Block" has "OP" in a certain cell. The problem I am having is if block 1 doesn't have "OP" in the designated spot, but block 2 does, It won't total it if block one doesn't say "OP" please help.
=IF(ISNUMBER(SEARCH("OP",G1)),SUM(J10,+IF(ISNUMBER(SEARCH("OP",T1)),SUM(W10,+IF ETC ETC ETC,
Bookmarks