I am trying to find an average purchase price (listed in column H) for
purchase dates (column A) that occur between 11/01/1998 and 12/01/1998
and an additional criteria - that column G has "Pre-Period".

Right now I have this formula:

=AVERAGEIFS
(H2:H809,A2:A5121,"=11/1/1998",A2:A5121,"<12/01/1998",G2:G809,"Pre-
Period")


This is returning #VALUE

Any suggestions on how to make this work?

THANK YOU!