ExcelBanter - countifs criteria

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - countifs criteria (https://www.excelbanter.com/excel-discussion-misc-queries/256881-countifs-criteria.html)

Anvil22

countifs criteria

I am trying to count blank cells in as part of the second criteria.
=COUNTIFS(I2:I126,"reg",J2:J126," ")

I have used this =COUNTIFS(I2:I126,"reg",countblank J2:J126)
I can't get the number of blank cells.

can anyone help.
Thanks,
Dick

Teethless mama

countifs criteria

=COUNTIFS(I2:I126,"reg",J2:J126,"")

"Anvil22" wrote:

I am trying to count blank cells in as part of the second criteria.
=COUNTIFS(I2:I126,"reg",J2:J126," ")

I have used this =COUNTIFS(I2:I126,"reg",countblank J2:J126)
I can't get the number of blank cells.

can anyone help.
Thanks,
Dick

Paul

countifs criteria

Try this COUNTBLANK(put cell references here).

"Anvil22" wrote:

I am trying to count blank cells in as part of the second criteria.
=COUNTIFS(I2:I126,"reg",J2:J126," ")

I have used this =COUNTIFS(I2:I126,"reg",countblank J2:J126)
I can't get the number of blank cells.

can anyone help.
Thanks,
Dick

Anvil22

countifs criteria

Teethless mama - Work like a charm - thank you.

"Teethless mama" wrote:

=COUNTIFS(I2:I126,"reg",J2:J126,"")

"Anvil22" wrote:

I am trying to count blank cells in as part of the second criteria.
=COUNTIFS(I2:I126,"reg",J2:J126," ")

I have used this =COUNTIFS(I2:I126,"reg",countblank J2:J126)
I can't get the number of blank cells.

can anyone help.
Thanks,
Dick

Anvil22

countifs criteria

"Teethless mama" wrote:

=COUNTIFS(I2:I126,"reg",J2:J126,"")

"Anvil22" wrote:

I am trying to count blank cells in as part of the second criteria.
=COUNTIFS(I2:I126,"reg",J2:J126," ")

I have used this =COUNTIFS(I2:I126,"reg",countblank J2:J126)
I can't get the number of blank cells.

can anyone help.
Thanks,
Dick

All times are GMT +1. The time now is 05:30 PM.