part of my macro has this equation:
it counts the number of Base, Riser, Cone, TS ( these are in column K), if column O contains Sanitary.
What if I want to add one more variable where this equation counts These items ONLY when there is also the number 4 present in column K ?
any help is appreciated
it counts the number of Base, Riser, Cone, TS ( these are in column K), if column O contains Sanitary.
What if I want to add one more variable where this equation counts These items ONLY when there is also the number 4 present in column K ?
any help is appreciated
VBA Code:
n = n + Application.Sum(Application.SumIfs(Range("C" & sr & ":C" & lr), Range("K" & sr & ":K" & lr), _
Array("*Base*", "*Riser*", "*Cone*", "*TS*"), Range("O" & sr & ":O" & lr), "*SANITARY*"))