Helen Wills
New Member
- Joined
- Nov 14, 2014
- Messages
- 27
- Office Version
- 365
- Platform
- Windows
Hi. I have a formula that works so far....
=COUNTIFS('sheet name'!U5:U78, "2020", 'sheet name'!V5:V78, "q3", 'sheet name'!Y5:Y78, "delayed")
However, in the next one i want to count all that are pending or the cell is blank ie
=COUNTIFS('sheet name'!U5:U78, "2020", 'sheet name'!V5:V78, "q3", 'sheet name'!Y5:Y78, "pending") ADDED TO
COUNTIFS('sheet name'!U5:U78, "2020", 'sheet name'!V5:V78, "q3", 'sheet name'!Y5:Y78, "blank cells")
I know that "blank cells" is not what i put here, but i am struggling how to use countblank as well as all the other criteria. Can anyone help?
=COUNTIFS('sheet name'!U5:U78, "2020", 'sheet name'!V5:V78, "q3", 'sheet name'!Y5:Y78, "delayed")
However, in the next one i want to count all that are pending or the cell is blank ie
=COUNTIFS('sheet name'!U5:U78, "2020", 'sheet name'!V5:V78, "q3", 'sheet name'!Y5:Y78, "pending") ADDED TO
COUNTIFS('sheet name'!U5:U78, "2020", 'sheet name'!V5:V78, "q3", 'sheet name'!Y5:Y78, "blank cells")
I know that "blank cells" is not what i put here, but i am struggling how to use countblank as well as all the other criteria. Can anyone help?