CountIf Function with range

[kiwikiki718]

I have two different columns on different worksheets that I want excel to count. currently I am unsure on how to add another logic to this formula please help.

So basically I want excel to count if

'Upload New Class'!$B$2​

is found in table 1 with range's X-Z OR table 2 with ranges X-Z.

B

elow is the formula I have so far which works but I need to add another logic.​

=COUNTIFS('TK-Current Classes_Desc.'!$A$2:$A$283,'Upload New Class'!$B$2)

thanks in advancde

 

[etaf]

you could just use
countifs() + countifs()
if not found result is 0
otherwise adds together
not sure of your range though - you say X-Z but using range A
Also only have 2 elements - so a countifs is not really need
countif() would work

 

[kiwikiki718]

you could just use
countifs() + countifs()
if not found result is 0
otherwise adds together
not sure of your range though - you say X-Z but using range A
Also only have 2 elements - so a countifs is not really need
countif() would work

thank you this worked.

one more thing, how would I get excel to display a text instead of a number.

example if >=1 display "Error" else display ""

 

[etaf]

=IF( cell or formula result >=1 , "error", "")