Adding another condition to COUNTIFS formula

[Viq]

Hello

I am stuck on adding an extra condition to a COUNTIFS formula. So the below formula helps me to find how many activities took place between each month, and also applies this to a filtered data range. However I need to add into the formula the weightings I have assigned against each milestone, so it provides a sum of the total weightings for each month.

In the milestone tab, I have added in the weightings in column T.

=COUNTIFS('Milestone Data'!$R$2:$R$1350,">="&ALL!I3,'Milestone Data'!$R$2:$R$1350,"<="&ALL!J3)

Please can you help

 

[GraH]

Hi,

Allow me to offer 2 tips:
1. read the inner help on the function
2. perhaps you need to change from countifs to sumifs?

 

[Viq]

Thank you for the above.

Just that I thought I could add in the sumiff function into the counifs formula above? I'm still not sure what to do.

 

[GraH]

Perhaps add some screenshots of your data or use the XL2BB add-on to post a sample content of your sheets? Hard to give advise without.

 

[Viq]

 

[GraH]

Not yet entirely sure, but could try [B3] =SUMIFS( 'Milestone Data'!$T$2:$T$1350, 'Milestone Data'!$R$2:$R$1350,">="&ALL!I3,'Milestone Data'!$R$2:$R$1350,"<="&ALL!J3)

 

[Viq]

Hi there

I have just tested this out, very minor tweaks, but it worked! Thank you so much. I can see how the SUMIFS function works now I was then able to apply it to the maturity achieved formula, again with small adjustments.

Maturity Planned
=SUMIFS('Milestone Data'!$U$2:$U$1350,'Milestone Data'!$R$2:$R$1350,">="&ALL!J3,'Milestone Data'!$R$2:$R$1350,"<="&ALL!K3)

Maturity Achieved
=SUMIFS('Milestone Data'!$X$2:$X$1350,'Milestone Data'!$S$2:$S$1350,">="&ALL!J3,'Milestone Data'!$S$2:$S$1350,"<="&ALL!K3)

 

[GraH]

Glad you found your way and that I was of some assistance to you. Thx for the feedback.