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)

You can use the SUMIFS function where you have multiple conditions, and this can act directly on the data in Sheet1. The syntax is a bit different than SUMIF. Put this in I2 of Sheet1:

=SUMIFS(F:F,B:B,"01/18/2019",A:A,"N")

I'm not sure why you show the date as 16th in Sheet2. You can replace that date (and the quotes) with TODAY() if you wish, and if N is contained in H2, then you might have this:

=SUMIFS(F:F,B:B,TODAY(),A:A,H2)

which can easily be copied down if you have other values in column H.

Hope this helps.

Pete

You guys are great! Thanks so much!