Home

Formula Help

Highlighted
Nathan Harrington
Occasional Visitor

Formula Help

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?

1 Reply

Re: Formula Help

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