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
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