Using COUNTIFS between dates when one more condition - can they be in one formula or not?

[RogerRangeRover]

Hi!

If I have a the following formula to count the cell A1 only if it has a date which is equal or higher than the date in cell B1, and equal or lower to the date in cell, as follows:

COUNTIFS(A1;">="&B1;A1;"<="&B2)

Now I would only want to count as per this condition if the cell A2 has a value "Z".

Can you do this by using one COUNTIFS formula alone? If I use COUNTIFS()+COUNTIFS() the result would be 2: one count for the value Z and one for the date, although the aim is to have one count when both the date meets the condition and the value is Z.

It seems you canīt for example do this

COUNTIFS(A2;"Z";A1;">="&B1;A1;"<="&B2) or
COUNTIFS(A2;"Z");COUNTIFS(A1;">="&B1;A1;"<="&B2) or
COUNTIFS(A2;"Z")(COUNTIFS(A1;">="&B1;A1;"<="&B2))

For this one I would really want to avoid using a helper column.

Many thanks for any ideas!