I have google sheet, I'm able to count same background colored column in the sheet with help of this addon "https://chrome.google.com/webstore/detail/custom-count-and-sum/njiklelndjpdbdngfkdgeijcpfabfgkb"
Now I want to add condition here, I just want to count background color only if B column empty. How can I do that?
This is what now I have
And this is what I want
to count background color only if B column empty
you can wrap it into IF
fx:
=IF(COUNTA(B2:B)=0, COUNTBACKGROUNDCOLOR("A2:A9", "A2", A2:A9), "pending")