Count IF Formula Help

[Viq]

Hello, I was hoping to get some help

I need to add in an extra element to this formula which will allow me to count all the milestones that have passed. The below formula currently provides How many milestones are contained within each month. I am planning to place the extended formula in L3 as per screen shot below.,

=COUNTIFS('Milestone Data'!$R$2:$R$821,">="&ALL!M3,'Milestone Data'!$R$2:$R$821,"<="&ALL!N3)

I have added this data in the 'Milestone Data' tab in Column Z. For the Milestone that have passed, I have provided a value of 1, and those that have failed, I have provided a value of 0. Not sure if these would be good values to use, as I want to represent into a graph.

How can I add this into the formula? I was thinking of another counfif formula at the end of it?

 

[jasonb75]

Just sum the 1's and 0's in column Z using the same SUMIFS formula that you did in your previous thread.

 

[Viq]

Hi Jason

I have only had the opportunity to try this morning and I think it's worked using the SUMIF formula

Many thanks for your direction