Formula Help

[Nathan Harrington]

Hello,

I am trying to get it so when I put Yes in the Connected column, it will add the PSU # from column G into the box labeled Completed, put the average of PSU that has been Connected in the box labeled BSI, and add the CHL from column F that has been Connected into the box labeled CHL Sold.

Can anyone please help me?

[#2]

Hi, Would there be multiple connected items i.e. multiple rows with 'Yes' in Column L? If yes, what would want in the Completed & CHL sold boxes: Sum, Count or Individual Values?

For the BSI box use the following formula:

=SUMIF($L$7:$L$70,"Yes",$G$7:$G$70)/COUNTIF($L$7:$L$70,"Yes")