I have on worksheet A, column AJ, the dollar amounts of various items. The
column is continous with different dates, column H, throughout the range.

On worksheet B I want to add the total for a specific month (mm/dd/yyyy),
cell J, from that data input on worksheet A. I use the below formula for
other calculations and it works fine. It just gives me total numbers (i.e.
Opened = 5, Closed = 10):

=SUMPRODUCT(--(TEXT(worksheet A!H8:H2000,"mmm/yyyy")=TEXT(J1,"mmm/yyyy)))

I need a formula that will calculate/add the total dollar amount (specific
date range) of worksheet A input and be seen on worksheet B ($54,875.45).

Thanks.