mercredi 23 octobre 2019

How to countif or sumif in google sheet with background color count based on other cell value

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

enter image description here

And this is what I want

enter image description here

Aucun commentaire:

Enregistrer un commentaire