Mr Excel, as you can see by my e-mail address I am in the military. I have been working on a spreadsheet that will compute a variety of calculations for the accounting of personnel and their individual data. Iam at a loss as to how to calculate the ranges I want. I can copy the correct formula to the rest of this project once I get the right answer. I have talked to many personnel in the system who are "experts" and continue to get that "deer in the headlight" look from them. I hope you can help. Here is my problem: In a any cell or perhaps another worksheet, I need to search two ranges for certain criteria and get a total number. I want to search i.e. B4:B40 for any cell that contains "O*" (the letter O and 1-9 using the wildcard symbol). I then need that same formula to search i.e. K4:K40 for any cell that contains "P" (the letter P). I then need the sum of how many cells met both sets of criteria. I greatly appreciate any help I can get. This will assist hundreds of troops.
SFC Michael F. Lingeman
SFC Michael F. Lingeman