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