Count Blank If Multiple Conditions Match

[Pupishi]

Hello,

I am trying to count blanks when multiple values match by using COUNTIFS() or SUMIFS().
For example, I would like to get the sum of blanks in Apr for values A only in column B.
However, whenever I try to do it, I either get a #SPILL! error or #VALUE error.

Would be grateful for any help to get this issue fixed. Thank you.

 

[kevin9999]

Another option with Sumproduct()

Book1
	E	F	G
29		Apr	May
30	A	13
31	B
Sheet1

Cell Formulas
Range	Formula
F30	F30	=SUMPRODUCT(($E$1:$X$1=F$29)*($B$3:$B$26=$E30)*($E$3:$X$26=""))

 

[Pupishi]

This worked perfectly!! Thank you so much for the swift solution. Really appreciate it!

Another option with Sumproduct()

Book1
	E	F	G
29		Apr	May
30	A	13
31	B
Sheet1

Cell Formulas
Range	Formula
F30	F30	=SUMPRODUCT(($E$1:$X$1=F$29)*($B$3:$B$26=$E30)*($E$3:$X$26=""))

 

[kevin9999]

Happy to help & thanks for the feedback