Forum Discussion

Nathan Harrington's avatar
Nathan Harrington
Copper Contributor
Feb 02, 2018

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?

Formulas & Functions
Need Help

1 Reply

  • Sudhir Nair's avatar
    Sudhir Nair
    Copper Contributor
    Feb 08, 2018

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

Resources