CountIf, Excluding Columns Or Cells...

CountIf formula to count number of times certain text appears, but want to leave out every 8th column from the selected range...is this possible?

Formula is currently, =COUNTIF(F17:AYF17,"CAN")...but I don't want to total every 8th cell within that range.

In the column to be excluded, it could be one of four values (MOT, CAN, VOT, CLEAR).

What about in a different row, like a Header ?
Is there anything common that could flag which cells should be included (or NOT included) ?

So we could do something like
=COUNTIFS(F17:AYF17,"CAN",F$1:AY$1,"<>NotThisOne")

I'm just making up the 'notthisone' string, but hoping there is something there than can be used logically.

Maybe attach a sample file, maybe we can find something.

Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

File attached...thank you all your help!

Try
=COUNTIFS(F17:AYF17,"CAN",F$14:AY$14,"<>Week")

I received #VALUE! when entering that formula.

I typed the range.. AY$14 should be AYF$14

Wow, it works...thank you so much, you are a life saver!!!!! Cannot tell you how thankful I am!!! I really appreciate!!!!

You're welcome.

Would I be able to add another criteria to be added in that formula; for instance I'm already counting the number of times 'CAN' appears in the range, how would I also be able to count all figures > than 0 in the range as well?

Nevermind...I answered my own question.

Is there a way to use this same formula, but only for a period of 6 weeks? My columns signify the days, weeks of the year...if I only want to count the totals for a period of 6 weeks, how would I be able to go about that?

Originally Posted by Jonmo1

Try
=COUNTIFS(F17:AYF17,"CAN",F$14:AY$14,"<>Week")

=COUNTIFS(DAILY!MA39:XFD39,"100%",DAILY!MA$39:ABJ$39,"<>FW")

Can you tell me why this is not working. I want to count the number of times 100% is in row 39, but I want to ignore every 8th column. thanks