How do I count a certain number in a column given within a row?

[Bjarnebananen]

Hi there.

I have a COUNTIFS formula where I try to count a certain number, with a condition of the week number. Between D6 and P6 i have the week numbers that the formula should search for, however, I don't think this is correct. Anyone who knows how I could make it work? :-)

=COUNTIFS(Data!$Z:$Z;"Arm*";Data!$AD:$AD;D6:P6)

(In the Data sheet, I'm looking for how many times the word arm (plus maybe some more text hence the *) occurs in a given week.)

Thanks in advance

[Pete_UK]

Try it like this:

=SUM(COUNTIFS(Data!$Z:$Z;"Arm*";Data!$AD:$AD;D6:P6))

This is an array formula, so you need to use the key combination of Ctrl/Shift/Enter (CSE) to confirm it, rather than the usual Enter.

Hope this helps.

Pete

[Bjarnebananen]

Hi Pete_UK!
This worked for me. Thank you very much! Have a wonderful day, kind regards from Copenhagen.