Nested loop IF and COUNTIFS

[Izzy13]

Hi there!

This is my second time playing with excel, so please bear with me.

I have a string of data in column A (lets say the data name is John,James,Jerry,Jay and Jim) and with each data holding values. My intend is that the formula will compare the names with a cell (lets say G10 which houses the name John) and then only count the values of John that it is within range. The range itself is from another cell (I6 and H6 in this case)

=IF($A:$A=$G$10,COUNTIFS($E:$E,">="&$I$6,$E:$E,"<"&$H$6))

Just to rephase, the formula should pick out all Johns (since G10 is currently John) and count the values of Johns that is within the range. Instead of a number, the current return is FALSE.

Can somebody please help?

Thanks in advance.

 

[Fluff]

How about
=COUNTIFS($E:$E,">="&$I$6,$E:$E,"<"&$H$6,$A:$A,$G$10)

 

[Izzy13]

How about
=COUNTIFS($E:$E,">="&$I$6,$E:$E,"<"&$H$6,$A:$A,$G$10)

Okay you're quickly becoming my savior knight in this page

But for real, how $A:$A,$G$10 work? There is no equal (=) sign.

 

[Fluff]

You don't need the = sign, if you don't specify a criteria ( like >, <= etc) then Xl assumes you mean =.