I will post the two formulas I am using now and I hope someone can help
me figure out how to make it into 1. Thanks in advance.

#1 =COUNTIF(location, "shop") total=20
#2 =COUNTIF(date,""&B10)-COUNTIF(date,""&B11)
total=10

Explained(as the best I can)

#1 It simply counts the number of times that the "Shop" was used all
months
#2 Counts the total number of times that "All" were used for a
particular month.

Goal

I want to be able to count how many times the "Shop" was used in each
particular month. I have the "Shop total" and the "All by month" but
was looking to get "Shop by each month"

Thanks in advance


--
rileym
------------------------------------------------------------------------
rileym's Profile: http://www.excelforum.com/member.php...o&userid=37905
View this thread: http://www.excelforum.com/showthread...hreadid=574365