how do count multiple cells across 12 tabs into one ?
In every sheet I have a T.O table like the one posted but I want to count each sheet into one table. What formula do I use?
MacBook Pro 13″, macOS 15.0
Your formula for the COUNTIFS() function is incorrect.
COUNTIFS() takes multiple of two parameters - the first is a range, followed by a value. Each cell in the range is checked against the value, and the counter is incremented for each match.
You can have multiple ranges (each with its own value), but you just append them as additional parameters to COUNTIFS(), but in this case, the results are ANDed (i.e. the corresponding cell in the second range ALSO has to pass the check), which doesn't sound like what you want.
Instead, I think you want to count all the 'A' values across the tables. To do this you need to sum them:
=COUNTIFS(August::I1:I21,"A") + COUNTIFS(September::I2:I21,"A") +...