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
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