COUNTIF with 2 conditions

[Justme5]

Hi All,

Very new to this, so if anybody can help it would be greatly appreciated. In summary I want to count all rows that have a value of today or earlier BUT the row is not closed. Here's what I've put together with errors:

=COUNTIF($F4:$F24,"<="&TODAY()) AND ($G4:$G24,"<>""CLOSED")

Any help would be great!

Cheers

JM5

[daddylonglegs]

Try using SUMPRODUCT like this

=SUMPRODUCT((F4:F24<=TODAY())*(G4:G24<>"Closed"))

[VBA Noob]

Maybe

=SUMPRODUCT(($F4:$F24<=TODAY())*($F4:$F24<>"")*($G$4:$G$24<>"closed"))

VBA Noob

[Justme5]

What can I say!
Fast response and sorted me out a treat, really appreciate it guys, thanks a bunch

JM5