Countifs Formula Issues

[MarkReddell]

Hello Mr Exceler's,

I've never have any problems with this formula before, however, I can't seem to get this to work. Is there any suggestions???

Ex: =IF(COUNTIFS($A$7:$A7,$A7>=C$3)>=1,C$4*COUNTIFS($A$7:$A7,$A7>=C$3),"")

 

[Joe4]

I believe you are structuring the COUNTIFS formulas incorrectly.
I think that instead of like this:

COUNTIFS($A$7:$A7,$A7>=C$3)

it should be like this:

COUNTIFS($A$7:$A7,">=" & C$3)

 

[MarkReddell]

I believe you are structuring the COUNTIFS formulas incorrectly.
I think that instead of like this:

COUNTIFS($A$7:$A7,$A7>=C$3)

it should be like this:

COUNTIFS($A$7:$A7,">=" & C$3)

Thanks very much Joe4 !!! Have a very blessed day!!!!!!

 

[Joe4]

You are welcome.
You too!