Sorry about all this, the command did in fact work, I managed it
Thanks for your help
Jeannie

"T. Valko" wrote:

Try this:

=SUMPRODUCT(--(TEXT($F$3:$F$276, "yyyymm")="200708"),--$G$3:$G$276)


--
Biff
Microsoft Excel MVP


"Jeannie" wrote in message
...
Hi,

I am trying to calculate the number of arrivals for the month of August on
a
spreadsheet. The month appears in column E, the date in column F and I
have
FALSE for departures and TRUE for arrivals in column G.

I have tried:
=SUMPROD(--TEXT($F$3:$F$276; "aaamm")="200708),--($G$3:$G$276=TRUE)
I have also tried
=SUMPROD(--TEXT($E$3:$E$276; "August")),--($G$3:$G$276=TRUE)

both formulas give me 0 when I should be getting 23

Any help would be greatly appreciated

Thanks
Jeannie


but I get 0 as a result when I should be getting 21