Need help with countifs please

[Pat1009]

I am in need of a VBA code for a Countifs with 3 ranges and 1 criteria per range.
column U:U has "Bellaire"
column AC:AC has "US XR TONER 8-5"
column Q:Q has "CHEVRON-XEROX CAMPUS

What would the VBA code look like, if I wanted to find anything in each column that met all the criteria?

 

[Pat1009]

Using the "Case Detail" worksheet, I need it to count Bellaire in column U:U (entire column), which is 79
Using the same worksheet and column, also count hou150, which is 501.
This should return a count of 580

 

[Cosmic Wizard]

Using the "Case Detail" worksheet, I need it to count Bellaire in column U:U (entire column), which is 79
Using the same worksheet and column, also count hou150, which is 501.
This should return a count of 580

Pat1009, then use =COUNTIF('Case Detail'!U:U,"*hou150*",'Case Detail'!U:U,"*Bellaire*"); i think you should try experimenting a bit with the formula now.
As you can see, you can just copy and paste the text you want in to the formula.