COUNTIF with a non contiguous range

B

BBM

Can I use COUNTIF to count the non-zero values in a group
of cells that are non-contiguous? The examples in help
all show a contiguous range ex. COUNTIF(B3:K3, ">0").

What I need is COUNTIF((B3, D3, F3, G3, J3),">0)

Excel chokes on this with a #Value error. I've figured
out a workaround, but I don't know why the non-contiguous
range doesn't work.

Thanks.

BBM
 

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

Similar Threads

COUNTIF Non Contiguous Cells Q 3
How to do COUNTIF when cells are not in a consequtive column? 4
SUMIF formula with non contiguous cells 2
using slope function with non contiguous cells 1
Copy .Areas.Item(1,2,3,4,5, etc.) to a column or a row 5
Looping through Non contiguous cells in a row 11
COUNTIF on NonContiguous Cells? 5
AVERAGE NON-ZERO CELLS ACROSS SEVERAL WORKSHEETS IN SAME WORKBOOK 8

Top