Google Sheet formula, need answer fast: countif (or countifs) on a sheet, multiple ranges but same criteria

Factual Questions
1

Hi, I’ve tried searching for this but can’t seem to find the answer.

In one cell I want to count the number of cells containing “A” but there are two separate ranges to look for those As. What’s the formula for this?

I tried this but no joy – =countifs(A1:V11,“A”,A12:T58,“A”)

I get #REF! Error Circular dependency detected. To resolve with iterative calculation, see File > Settings.

But that’s not helping me.

I’m working it and if I solve it I’ll circle back here. Thanks!

2

I found one problem and my new formula is now this:

=countifs(A1:V11,“A”,A12:Q24,“A”,A25:T58,“A”)

I now get #VALUE! Error Array arguments to COUNTIFS are of different size.

3

I’d spilt the references/ranges.
ie =countif(A1:A11,“A”)+countif(T12:T58,“A”)

4

I tried that but let me try again, since I fixed the logic error with the first attempt.

Thanks.

5

That worked! Thanks, @penultima_thule !

Here’s the final formula:

=countif(A1:V11,“A”)+countif(A12:S24,“A”)+countif(A25:S58,“A”)