SaraWitch
Active Member
- Joined
- Sep 29, 2015
- Messages
- 378
- Office Version
- 365
- Platform
- Windows
Hello peeps,
I want to count column H if it contains "Archive", "Update" or "Rename" and cell I is blank.
I have tried a combination of formulas, including:
=SUM(COUNTIFS($I8:$K$100,$H$8:$K100,{"Archive","Update","Rename"}))
=COUNTIF($H$8:$K100,"Archive")+COUNTIF($H$8:$K100,"Update")+COUNTIF($H$8:$K100,"Rename")+COUNTIF($I$8:$I100,"")
Lost count of the others I tried!
Any help would be gratefully received...
I want to count column H if it contains "Archive", "Update" or "Rename" and cell I is blank.
I have tried a combination of formulas, including:
=SUM(COUNTIFS($I8:$K$100,$H$8:$K100,{"Archive","Update","Rename"}))
=COUNTIF($H$8:$K100,"Archive")+COUNTIF($H$8:$K100,"Update")+COUNTIF($H$8:$K100,"Rename")+COUNTIF($I$8:$I100,"")
Lost count of the others I tried!
Any help would be gratefully received...