COUNTIF function across more than 1 column

Joined
Dec 19, 2012
Messages
1
Reaction score
0
Hi,

I have a question I hope somebody can help me with.

How do I setup a COUNTIF function so that it 'searches/uses' more than one column for results.

Example:
I have a spreadsheet with 20 columns - starting at A1 to T1 - and ending at A100 and T100. I want to use the COUNTIF function to 'search' all of these from A1/T1 to A100/T100 and tell me how many times the number 21 appears across that range of cells

Any idea how I can do this?

Thanks,

R
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top