Hi everyone,
I am using SUMPRODUCT to count multiple criteria in a number of columns, but I am unable to get my final "criteria" to work. I am currently counting criteria in columns H, M, O, and N using cell references to ease the effort of changing the criteria. However, I the last criteria that I am trying to add into the formula is the ability to count column L (which is a large text string) when it contains the word "Removing". the formula I am attempting to use (which is not working), is below:
The formula is working fine, up until the point that I added the last section ...... --(Combined!$L$2:$L$2500="*Removing*"))
If anyone has any guidance and/or direction, that would be greatly appreciated.
Bookmarks