Sorry, I guess I had a really "blonde moment". I just realized that the
formula that worked so well from January to July was actually copied from
another worksheet, which only had 276. This other worksheet that keeps
giving me 0 for August to December has 576 rows.
Now, I have a new problem, if I try to change the range from $F$3:F4F276 to
$F$3:$F$576 I get #VALUE, even for the formulas that worked previously
(January to July).
Any further help would be greatly appreciated
Thanks
Jeanne

"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