Maybe

=IF(AND(H14:H24="PAID"),"PAID",0)
It's an array formula so enter with Ctrl + Shift + enter

VBA Noob