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.

Column1	Actual sales	Promo sales	Actual sales distribution weight	Promo sales distribution weight
Nielsen	Bi-monthly	Bi-monthly	Bi-monthly
CatMan Solution	Weekly	Weekly
Source 3
Column1	Actual sales	Promo sales	Actual sales distribution weight	Promo sales distribution weight
Nielsen
CatMan Solution	Weekly	Weekly
Source 3

<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>

 

[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!