PDA

View Full Version : Solved: Formula Problems



john3j
03-17-2010, 12:16 PM
Hello All, Im trying to come up with a formula that counts the number of items that begin with the letter W and instances of QXS located in the column F on the sheet called "Summary Sheet". I dont know if I should be using a sumproduct or some variation of a count if. For other instances I just use a countif, but now I have two criteria and need them added. Please let me know if you can help.

Thanks:banghead:

mdmackillop
03-17-2010, 12:26 PM
Why not just add 2 CountIfs together