Counting in multiple column



I am struggling with a spreadsheet attempting to count events with criteria
in several columns.

Column A - MMM-YY date (only month and year are keyed in)
Column B - Reference Number (with blanks that have to be omitted from count)
Column C - Equipment Description (contains concantenation of 3 other columns)

I need to count only those lines where C meets one criterion, B is not blank
and A is in the correct month. I hope to put each in a X:X range so the
formulas will not have to be revised as new data is added. I tried
SUMPRODUCT but I think my cell formatting may not be correct to achieve this.
I also put in a cell range A1:A30 which did not solve the problem. I
struggle with picking up the dates appropriately as well. The output I am
seeking is:

Count of only those cells where Column C matches the equipment description
and Column B is not blank for the month required from Column A.

Any help would be greatly appreciated.

Luke M

You prb had trouble getting the month to match.


You could change the 1 to any number up to 12, or reference another cell
such as =MONTH(D1)

"Truck" could of course also be replace with a cell reference. Hope that



Thank you so much. I knew I was having trouble getting the logic to match
the date format. Great work-around!!


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