Hello
I am looking for a more simple formula to solve my problem, please reference attached example spreadsheet. I would like to count the value "S" OR "CL" in column F AND values with in column H by month.
I was able to come up with the crude formula but it is ugly...
=COUNTIFS(H:H,">=1-1-2012",H:H,"<=1-31-2012",F:F,"=S") + COUNTIFS(H:H,">=1-1-2012",H:H,"<=1-31-2012",F:F,"=CL")
Ultimately I would like to make a chart by month showing the results "January, February, March..."
I appreciate any help you can provide, Thanks For Your Help.
Bookmarks