Help Using COUNT or SUM/IF???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Excel A CountIF question... I think 2
Excel Help with dates 2
Count cells if next column has text 2
EXCEL COUNTIF FORMULA 0
Formula Count dates multiple criteria 3
Formula Help 4
Multiple logic tests 0
If SUMPRODUCT & Blank cells 7

Back
Top