SUM CountIFS

[dragonmouse]

Simple question for the Pro's.

I have two columns A and B. Both Columns may contain Letters A-D. I want to count all the "A" In Column A and all the "A" in column B then add them together.

I tried using =COUNTIFS($A:$A,"A",$B:$B,"A") however it would only count one column. I tried using =SUM(COUNTIFS($A:$A,"A",$B:$B,"A")) but it's still only counting one column.

Priority (column A)	New Pri (Column B)	"A" PRI Count (formula)
A	B	1​
A	A	2​
B	A	1​
C	A	1​
D	A	1​
A	A	2​
B	C
B	C
B	D
C	A	1​

 

[Fluff]

You should avoid using whole column references, especially in array formulas which that is.

 

[hrayani]

This did not work=IF(A2="A"...) gave me an error that it didn't recognize it as a formula

=SUMPRODUCT(($A:$A="A"))+($C:$C="A")) worked. A slight modification to "Fluff's" formula but the essence worked

Works for me... I do not know why it is not working for you
Anyways you have found the solution by @Fluff