Hey guys, Firstly just wanted to say a big thanks to "DerbyDad03" for the help with my issue a while back - http://www.computing.net/answers/of... Suggestion worked like a charm and I was able to get the excel formula up and running, which saved me a lot of time!!! Secondly, just hoping someone can shed some light on how to set up on a couple of new formulae I need: * First: I need a function that counts a row only if BOTH of the following conditions within that row are met: K3:K15 = "Oct-08" H3:H15 = "PDM" * Second: Same deal as above, but with a third, additional criteria - ie count the row if all of the conditions for it are met: K3:K15 = "Oct-08" H3:H15 = "PDM" M3:M15 = "Yes" Tried a combination of "Countif" and "AND" functions, but with no luck, so any help would be greatly appreciated. Thanks in advance, Chris

use sumproduct (the double - forces it to evaluate the expression in the brackets to 1 or 0): =SUMPRODUCT(--(K3:K15="Oct-08"),--(H3:H15="PDM),--(M3:M15="Yes")) Note this is pretty slow if you have a lot on one sheet. Also note if your dates (Oct-08) are formatted as dates, you might need to use datavalue for the condition to work. HTH

Thanks heaps mate! Exactly what I needed. Legend!