Hi JMB,

This worked perfectly, I did not realise that I also have:

=COUNTA(August!AT:AV)-3

The sumproduct does not work for this, I must be doing something wrong, can
you assist?

Thanks
Tammy

"JMB" wrote:

=Sumproduct(--(August!E1:E100="DEN"), --(August!I1:I100="NSW"))

If you don't have XL 2007, Sumproduct will not accept an entire column, such
as E:E, but E1:E65535 would work.


"Tammy" wrote:

Hi,

I have the following formula:

=COUNTIF(August!I:I,"NSW")

I need help editing this. I only want it to return the values IF:

August!E:E,"DEN"

Can anyone assist?