lookup value based on date range

Hi Everyone,

Got a spreadsheet with 2 sheets. Sheet1 has columns for Name (A1), Amount (A2) and Date (A3), sheet 2 is my invoice. On the invoice I have Period Covered in two cells, a start (H8) and end (I8). The first item on the invoice is a qty cell (b13). I'm looking for a way to have excel count the total names from Sheet1 (A1) where the Date (A3) is between the Date Range on Sheet 2 (H8 - I8).

A little more background:
I run a server for a small company and charge them for each account I create and then a small monthly fee to maintain the account. Sheet 1 tracks the created accounts. Sheet 2 is my invoice, so at the end of each month, I wanted to update the start and end dates on the invoice and have excel insert the total accounts I created for that month.

Thanks,
Kevin

Sample.xlsx

Try this...

Got it... used SUMIFs... thanks for pointing in the right direction.