- Joined
- Mar 2, 2017

- Messages
- 2

- Reaction score
- 0

__ |

__A B__

_1 | A A

_2 | A B

_3 | E C

_4 | E D

_5 | B E

_6 | B F

_7 | F G

_8 | F H

_9 | C A

10 | C B

11 | G C

12 | G D

13 | D E

14 | D F

15 | H G

16 | H H

I want to count where column A = A/B/C/D AND column B = E/F/G/H

I try it work with this formula,

=SUMPRODUCT(((A1:A100="A")+(A1:A100="B")+(A1:A100="C")+(A1:A100="D"))*((B1:B100="E")+(B1:B100="F")+(B1:B100="G")+(B1:B100="H")))

But it's too complicated.

I try to simplify the formula with this one, it doesn't work.

=SUMPRODUCT(((A1:A100={"A","B","C","D"}))*((B1:B100={"E","F","G","H"})))

Is there other simple way to do this?