I have a SUMIFS formula that I am using to count 5 different criteria before providing a sum. The problem I am running into is one of the columns of criteria is a number, and I need to be able to sometimes use a wildcard to count that criteria. Obviously the * wildcard isn't working. Does anyone know of a good workaround for this?
Here is my formula: =SUMIFS(PostPrePxData!$J:$J,PostPrePxData!$G:$G,"151-180BFR",PostPrePxData!$E:$E,"="&$B$3,PostPrePxData!$C:$C,"="&$G$3,PostPrePxData!$F:$F,"="&$L$3,PostPrePxData!$A:$A,"="&$Q$3)
The data in column PostPrePxData!$C:$C is a number. In some cases it will be compared to a number and in others it will need to be compared to a wildcard. There is a drop down in cell G3 that the user can select to either look at all of the data from column PostPrePxData!$C:$C or just a portion of the data.
Here is my formula: =SUMIFS(PostPrePxData!$J:$J,PostPrePxData!$G:$G,"151-180BFR",PostPrePxData!$E:$E,"="&$B$3,PostPrePxData!$C:$C,"="&$G$3,PostPrePxData!$F:$F,"="&$L$3,PostPrePxData!$A:$A,"="&$Q$3)
The data in column PostPrePxData!$C:$C is a number. In some cases it will be compared to a number and in others it will need to be compared to a wildcard. There is a drop down in cell G3 that the user can select to either look at all of the data from column PostPrePxData!$C:$C or just a portion of the data.
