I want my formula to count the blank cells in another sheet and also by a particular status

Melitta

=COUNTIF(AND(NOT(ISBLANK({My sheet - Unit}),{My sheet - Status}, "New Request")))

Peggy Parchert

Hello @Melitta

Hope you are well. Would this work?

=COUNTIFS({My sheet - Unit}, "", {My sheet - Status}, "New Request")

Peggy

Peggy Parchert

Hello @Melitta

Hope you are well. Would this work?

=COUNTIFS({My sheet - Unit}, "", {My sheet - Status}, "New Request")

Peggy

Melitta

@Peggy Parchert

I had tried something similar at first but didn't get it to work and was slowly making it more complicated for myself.

Thank you very much for your guidance.

Peggy Parchert

@Melitta -

Happy to help. Have a great day!

Peggy

Melitta

@Peggy Parchert

I spoke too soon. It counts the non-blank cells when I want it to count the blank cells.

Any ideas?