Formula not working

B

Brandy

Trying to use criteria in 4 columns, one is a referral
received this month. Any ideas why this does not work?

=SUMPRODUCT(--(F6:F500="F"),--(G6:G500="C"),--
(O6:O500="C"),--(TEXT((A5:A500,"mmm")="Sep"))
 
B

Bob Phillips

=SUMPRODUCT(--(F6:F500="F"),--(G6:G500="C"),--
(O6:O500="C"),--(TEXT((A6:A500,"mmm")="Sep"))

the ranges must be same number of rows
 
Top