Formula Help

Nathan Harrington
Occasional Visitor

Formula Help



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:


Related Conversations