COUNTIFS for 2 criteria

[VPLUMWOOD]

I am trying to count how many times something appears in a range of multiple columns,

So the below is counting how many times the criteria in SummaryAll U2 appears - which is 8 and correct, but I need it to also count if criteria in SummaryAll E2 also appears?

Is this doable?


=COUNTIFS('Data From Arbor'!$K$2:$K$5000,'Summary All'!U2,'Data From Arbor'!$AG$2:$AG$5000,'Summary All'!U2,'Data From Arbor'!$AM$2:$AM$5000,'Summary All'!U2,'Data From Arbor'!$AO$2:$AO$5000,'Summary All'!U2,'Data From Arbor'!$M$2:$M$5000,'Summary All'!U2,'Data From Arbor'!$AI$2:$AI$5000,'Summary All'!U2,'Data From Arbor'!$AA$2:$AA$5000,'Summary All'!U2,'Data From Arbor'!$AC$2:$AC$5000,'Summary All'!U2,'Data From Arbor'!$AK$2:$AK$5000,'Summary All'!U2,'Data From Arbor'!$O$2:$O$5000,'Summary All'!U2,'Data From Arbor'!$Q$2:$Q$5000,'Summary All'!U2,'Data From Arbor'!$S$2:$S$5000,'Summary All'!U2)

 

[VPLUMWOOD]

Can you include row and column numbers in both pictures, but second one in particular. Which cell is E2 and U2?

Ideally if you could post a subset of these data (suitably anonymised) using XL2BB then we could derive a solution without having to set it all up from scratch.

Thanks

I've added - sorry for the delay, I was on Annual Leave.