Trouble with Countifs

[Tridiro]

Hello Everyone,

I'm having a problem getting a COUNTIFS formula to work correctly. I have two columns of numbers; Both columns contain empty cells. I need to count all the cells in column A that contain numbers, but only if there is a number in the adjacent cell of column C.

Here is what is came up with, but it doesn't work.

=COUNTIFS(Equip!A:A,ISNUMBER(Equip!A:A),Equip!C:C,ISNUMBER(Equip!C:C)

 

[Aladin Akyurek]

Hello Everyone,

I'm having a problem getting a COUNTIFS formula to work correctly. I have two columns of numbers; Both columns contain empty cells. I need to count all the cells in column A that contain numbers, but only if there is a number in the adjacent cell of column C.

Here is what is came up with, but it doesn't work.

=COUNTIFS(Equip!A:A,ISNUMBER(Equip!A:A),Equip!C:C,ISNUMBER(Equip!C:C)

Try...

=SUMPRODUCT(--ISNUMBER(Equip!A2:A1000),--ISNUMBER(Equip!C2:C1000))

 

[Tridiro]

Thanks, That did the trick

 

[Aladin Akyurek]

Thanks, That did the trick

You are welcome. Thanks for providing feedback.