IF AND Formula

Amanda Medina

Hello,

I am trying to get this formula to work. I need to calculate how many rows are "available" AND have a "1". I think I need this formula:

=IF(AND([Availability]15:[Availability]23="Available", [Tech Level]15:[Tech Level]23 = 1), 1)

but it keeps removing the brackets around Availability:

=IF(AND(Availability15:Availability23 = "Available", [Tech Level]15:[Tech Level]23 = 1), 1, 0)

and saying Invalid Operation.

John Jonassen

No need to worry about the brackets around Availability, when if you notice, they are used when the Column name has a space of special character. One word column names don't require it.

You are probably wanting to do

=COUNTIFS([Availability]15:[Availability]23, "Available", [Tech Level]15:[Tech Level]23, "1")

John Jonassen

No need to worry about the brackets around Availability, when if you notice, they are used when the Column name has a space of special character. One word column names don't require it.

You are probably wanting to do

=COUNTIFS([Availability]15:[Availability]23, "Available", [Tech Level]15:[Tech Level]23, "1")

Amanda Medina

Yes! Thank you!