=SUMPRODUCT(--($E$3:$E$276;"August"),--($G$3:$G$276))

or maybe

=SUMPRODUCT(--($E$3:$E$276,"August"),--($G$3:$G$276))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"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