Hi! See attached doc for reference, but I need a formula to count # of markets. I need to count a 1 for either retain or sales revenue >0 for each project, though the data is in different columns.
@AL789 I solved this with an array formula in the attached. In pre-Office 365 you would have to press Ctrl Shift Enter to confirm this type of formula after entering it.
Preview file
23 KB
1 best response
Accepted Solutions
best response confirmed by
AL789 (Copper Contributor)
@AL789 I solved this with an array formula in the attached. In pre-Office 365 you would have to press Ctrl Shift Enter to confirm this type of formula after entering it.
