Count number of cells with a specific text

[sajo9670]

Hi,
I am trying to count the number of cells matching a text (weekly, monthly, bi-monthly ect). The problem is that the range cannot be A1:A30, rather it is A10;A14;A18;A22....

How would I go about calculating the number of cells in the sheet where the actual sales in catman solution is weekly reported? In this case the answer should be 2.

[TABLE="width: 619"]
<tbody>[TR]
[TD]Column1[/TD]
[TD]Actual sales[/TD]
[TD]Promo sales[/TD]
[TD]Actual sales distribution weight[/TD]
[TD]Promo sales distribution weight[/TD]
[/TR]
[TR]
[TD]Nielsen[/TD]
[TD]Bi-monthly[/TD]
[TD]Bi-monthly[/TD]
[TD]Bi-monthly[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CatMan Solution[/TD]
[TD]Weekly[/TD]
[TD]Weekly[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Source 3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Column1[/TD]
[TD]Actual sales[/TD]
[TD]Promo sales[/TD]
[TD]Actual sales distribution weight[/TD]
[TD]Promo sales distribution weight[/TD]
[/TR]
[TR]
[TD]Nielsen[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CatMan Solution[/TD]
[TD]Weekly[/TD]
[TD]Weekly[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Source 3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col></colgroup>[/TABLE]

 

[sous2817]

Why can't it be A1:A30? Is it because there are false positives in that range or is it because data wouldn't appear in cells other than A10, A14, A18, etc. If it's because data won't appear, I wouldn't sweat calculating empty cells, as it will return a 0 and won't impact the final count.

Pre-excel 2007 version:

=Sumproduct(--(A1:A30="CatMan Solution"), --(B1:B30="Weekly"))

2007 or greater:
=COUNTIFS(B1:B30,"Weekly",A1:A30,"CatMan Solution")

There's no valid reason why I switched the arguements in the CountifS formula....they return the same value).

 

[sajo9670]

It is because of false positives. I need to know the actual sales from only Catman solutions. If I use A1:A30 then the actual sales for Nielsen and source 3 would be included which they should not.

 

[sous2817]

Did you at least try my solution?

 

[Sancdar]

If your range is always every 4th cell, you can throw in a MOD(ROW(),4)=X as a condition.

 

[sajo9670]

If your range is always every 4th cell, you can throw in a MOD(ROW(),4)=X as a condition.

I tried with the first solution and it worked brilliantly!
Thanks for the help!