Hi,
Hope someone can help.
I am trying to create a formula to lookup data in an input sheet and create a summary of key info and gap analysis.
the table looks simply as follows:
<tbody>
</tbody>
the formula I am using is:
=COUNTIFS($C$30:$C$39,"<>",$D$30:$D$39,$H30,$E$30:$E$39,{"PM1","PM2","PM3","PM4","PM5"},$F$30:$F$39,"Wave 1")+COUNTIFS($C$30:$C$39,"<>",$D$30:$D$39,$H30,$E$30:$E$39,{"PM1","PM2","PM3","PM4","PM5"},$F$30:$F$39,"Wave 2")
Is there a way to combine all of the PMs into a table and count any person which is in that table/named range against the PM column in the input sheet? This means I can just add the name of a new PM to the table rather than having to alter the formula.
Thanks in advance for any help.
Hope someone can help.
I am trying to create a formula to lookup data in an input sheet and create a summary of key info and gap analysis.
the table looks simply as follows:
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
the formula I am using is:
=COUNTIFS($C$30:$C$39,"<>",$D$30:$D$39,$H30,$E$30:$E$39,{"PM1","PM2","PM3","PM4","PM5"},$F$30:$F$39,"Wave 1")+COUNTIFS($C$30:$C$39,"<>",$D$30:$D$39,$H30,$E$30:$E$39,{"PM1","PM2","PM3","PM4","PM5"},$F$30:$F$39,"Wave 2")
Is there a way to combine all of the PMs into a table and count any person which is in that table/named range against the PM column in the input sheet? This means I can just add the name of a new PM to the table rather than having to alter the formula.
Thanks in advance for any help.