SUMIF Formula Using Multiple Criteria

[sheetsnewbie]

In Google Sheets, I'm trying to do the following:

If the checkbox in the "Paid?" column (F) is checked, then it will check the date in column G and verify that it matches L2. If they match, then it will pull the amount in C2 and place it into L3. Then as I continue down the spreadsheet, it will continue to add any amounts from column C IF the date in column G matches the date in L2.

The only formula I know to use right now is the following:
=SUMIF(F2:F45,TRUE,C2:C45)

And that will pull the amount in column C if the checkbox is checked. But how do I add in that ALSO the date in column G matches the date in L2?

 

[RaulARodriguez]

Change your formula to this :

=SUMIF(G:G,L2,C:C)

Where if the date on L2 matches the Date in Column It will add all of the values in column C

 

[RaulARodriguez]

If you want to test for column F to be true you try this

=SUMIFS(C:C,E:E,L2,F:F,TRUE)

Please note, I don not work with Google Sheets, I am not certain it has the same functionality Excel has.