countifs starts with

[Leticia]

Hi!

I have the formula COUNTIFS(INDIRECT("'"&$E12&"'!$I:$I");"A*")
but instead of A* (to say that it should select the values that start with that) I want to put a cell (f4) which says A.

How can I do that? Thank you very much

 

[Fluff]

How about

=COUNTIFS(INDIRECT("'"&$E12&"'!$I:$I");F4&"*")

 

[etaf]

COUNTIFS(INDIRECT("'"&$E12&"'!$I:$I");F4&"*")

 

[Leticia]

How about

=COUNTIFS(INDIRECT("'"&$E12&"'!$I:$I");F4&"*")

Hi! It does not work. I attach a capture of my case simplified (it does not let me use the mini sheet)

And the code in H5 is =COUNTIFS($B:$B;H$4&"*";$D:$D;"<>ZZZ";$C:$C;AND(LEFT($F5;4);RIGHT($F5;4)))

Issue 1: H$4&"*" does not get it as select if in B it starts with A
Issue 2: When Code has more than 1 values, I cannot select to choose always when some of the 4 digits match C

 

[Fluff]

Issue 1: H$4&"*" does not get it as select if in B it starts with A

That is not correct, it is the last part of the formula that does not work. Even if it did you would get 0 as single cell cannot equal both 1998 AND 2008

 

[Fluff]

Duplicate to: Countifs with multiple criteria OR

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.