Help Using COUNT or SUM/IF???

C

chickalina

I want to be able to return a count where the cell in columns J and M are
both "X".

Example: Colums J through M are cars andColumns N through O are the repairs.

I want to be able to count by car, how many times for each repair. So I
would need a total number of occurences where columns J and N are both equal
to "X"

I hope this makes sense.
 

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

Count cells if next column has text 2
Multiple Columns in Sum Range using SUMIFS 1
formula for arriving net difference 0
Needs help combining functions. 3
Formula Count dates multiple criteria 3
CONDITIONAL SUM FOR MULTIPLE CRITERIA IN SINGLE RANGE 1
Countif help needed 6
Get/Find criteria and copy sum 2

Top