Hi,

Put this in Cell F7

=COUNTIF(D4:D7,B4)
However, I do not understand 1 thing, the post is about SUMIFS, then why is your sheet showing COUNTIF?

Secondly when you input a Text, you input it like =SUMIFS(B3:AK3,B1:AK1,"XYZ"), when you input a Number, you input it like =SUMIFS(B3:AK3,B1:AK1,2013) & when you input a cell reference, you input like =SUMIFS(B3:AK3,B1:AK1,I4)

In you sheet, you input a Cell reference with Double Quote, which makes it a Text String instead of Cell Reference