Dear Ronmcfarlane,
you should use
=COUNTIFS($B$2:$B$6,">"&H2,$C$2:$C$6,"<"&H2)
Because " " inverted commas excel thinks it is a comment only to display..
Warm Regards,
Gawli Anil
On Tue, Mar 19, 2013 at 9:39 AM, Shuzbut wrote:
> I have the following formula
>
> =COUNTIFS($B$2:$B$6,"*>=*1",$
I have the following formula
=COUNTIFS($B$2:$B$6,"*>=*1",$C$2:$C$6,"<6")
Instead of counting if the number is between a hard coded 1 and 6 I want to
refer these top another cell
For Example
=COUNTIFS($B$2:$B$6,">=H2",$C$2:$C$6,"= and < operators within the " ".
Your assistance would be a
