Array Formulae Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following setup

A B C
1 Job Priority Satus
2 1 1 COMPLETED
3 2 1 CANCELLED
4 3 2 CANCELLED
5 4 3 WIP
6 5 1 WIP
7 6 4 WIP
8 7 1 COMPLETED

I am trying to calculate the number of priority 1 jobs that have been
completed and cancelled (the answer should be 4).

I have tried looking at Array formulas, but I have not been able to figure
them out. I would be grateful if anyone could offer any pointers.

Best regards
Neil
 
=SUMPRODUCT((B2:B100=1)*(C2:C100={"Completed","Cancelled"}))

I make it 4

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top