How do I use countif like sumif ie (range,criteria,count_range)

T

tmarie

I need to count cells with values by reference to a range in the same way
that sumif sums them ie countif(a1:a10,a40,c1:c10)
This doesn't work but I'm hoping there's another way?

cheers
thanks
 
T

T. Valko

Explain *in words* what you want this formula to do:

countif(a1:a10,a40,c1:c10)
 

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

SUMIF with criteria "<>" & "=" 4
Use TODAY() function as the criteria in a SUMIF formula 1
VLOOKUP or SUMIF for Multiple Criteria 2
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" 9
How can I define date range criteria in SUMIF formula? 1
How do I get started using the Countif, Countifs option with Excel 2
Countif with a Range of criteria 8
How do I count a range of cells from another columns criteria 6

Top