sumproduct and subtotal but with 2 conditions

[pauladkin]

Hello
I have managed by looking at the forum to cobble togther this formula which i
working nicel


=SUMPRODUCT(SUBTOTAL(3,OFFSET($A$29:$A$360,ROW($A$29:$A$360)-MIN(ROW($A$29:$A$360)),,1)),--($AD$29:$AD$360=N2)

and is give me a count of all my projects that are at the initiate stag
(n2=initiate) when I have filters o

What I would like to do if to have 2 counts - one of open and one of closed s
need to add a further condition that check if the project is open or closed

This would be $Ac$29:$Ac$360=p2 (p2=closed

Can anyone please advise me how I can do thi

Thank
Paul.

 

[Bob Phillips]

Try this

=SUMPRODUCT(SUBTOTAL(3,OFFSET($A$29:$A$360,ROW($A$29:$A$360)-MIN(ROW($A$29:$A$360)),,1)),--($AC$29:$AC$360=P2),--($AD$29:$AD$360=N2))