Formula help to sum a range if criteria across 3 ranges = blank, month and text string

Hi All

I'm trying to write an array formula to sum a column/range (G3:G76) if cells in 3 other columns (A, D & L) all match the below criteria:

A) cell is blank in column in column L
B) specific month in column D
C) specific text string in column A

So far I have:

=SUM(IF(ISBLANK($L$3:$L$76),(IF(MONTH($D$3:$D$76)=11,(IF(MATCH("ST",$A$3:$A$76),$G$3:$G$76,0))))))

The formula partially works, but the formula is not matching specific text string (I think).

Any pointers, ideas welcome and appreciated!

please try this array formula:

=SUM(ISBLANK($L$3:$L$76)*(MONTH($D$3:$D$76)=11)*("ST"=$A$3:$A$76)*$G$3:$G$76)

Originally Posted by Kaper

check if third argument in MATCH helps
MATCH("ST",$A$3:$A$76,0)

Thanks but this didn't do it.

Originally Posted by wcymiss

please try this array formula:

=SUM(ISBLANK($L$3:$L$76)*(MONTH($D$3:$D$76)=11)*("ST"=$A$3:$A$76)*$G$3:$G$76)

Spot on this worked! Thank you.

As a follow up question how do I add to this formula to match only dates over 30 days old in column D?