Conditional Count 2 Columns

[rileym]

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

[Joerg]

"rileym" <[email protected]> wrote in
message news:[email protected]...
>
> 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



Please have a look at array formulas
(http://www.cpearson.com/excel/array.htm)
This technique is much more powerful than single COUNTIFs.

Joerg