COUNTIF

Hi Gavin,

There is a new function with 2007 called COUNTIFS which allows you to put multiple conditions into your counting. The syntax is just about the same as for COUNTIF but you keep going, so:

=COUNTIFS(range1, condition1, range2, condition2,...)

The logic is that condition1 must be met AND condition2 must be met before anything is counted.

Hope this helps

Clare Glover
Microsoft Applications Trainer

Hi Gavin,

Sorry - thought you needed 2007! Your easiest method is probably with a pivot table where prob and impact are your row and column labels. The data in the middle needs to be another column - either a label type of column or indeed prob or impact. Just make sure that you change the field setting to COUNT not SUM if it's a numeric field.

Is this any better?

Clare