Formula not working

  • Thread starter Thread starter Brandy
  • Start date Start date
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"))
 
=SUMPRODUCT(--(F6:F500="F"),--(G6:G500="C"),--
(O6:O500="C"),--(TEXT((A6:A500,"mmm")="Sep"))

the ranges must be same number of rows
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula help 3
Summing days that match a criteria and date 3
=SUMPRODUCT... 9
Sumproduct with three arrays 2
Formula not working -- =SUMIF($F$6:$F$91,">=90",G6:I91) 5
COUNTIF NON DUPLICATED ROWS 2
counting multiple criteria using SUMPRODUCT and getting #VALUE err 1
Sum column of cells that already contain a formula 2

Back
Top