Forum Discussion
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...
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")