nested sumif statement help (is that the correct term?)

Hi guys,

I have a spreadsheet with a transaction type in Column A, Transaction Date in Column B, and a dollar amount in Column F.

I'm looking to sum the dollar amounts for a specific transaction type for today's date only.

I"m using the equation below and it works great besides pulling only today's "N" transactions. For now, i have to copy and paste all rows for today's transactions into sheet2, and then the formula's are run and displayed on sheet3. What am i missed to run this using a requirement of today's date?

Thank you!


=SUMIF(Sheet2!A2:Sheet2!A500000, "N", Sheet2!S2:Sheet2!S500000)