SUMIFS for multiple criteria

0
votes

I have a spreadsheet which I need to sum on column based on three criteria (employee name, payment option and dates). I currently have this formula 

=SUMIFS(C2:C10,B2:B10,"Jason",D2:D10,"Cash")

But it works regardless of the dates. I wanted to only show the value for today.

This is the link to the spreadsheet: https://docs.google.com/spreadsheets/d/1HshrfC05s_q9e5c78yReAUH8D2OBpcRBMTqJo8CPmwQ/edit?usp=sharing

Thanks in advance!

1
excelexcel-formula

1 Answers

2
votes

You need to add the third criteria:

=SUMIFS(C2:C10,B2:B10,"Jason",D2:D10,"Cash",A2:A10,TODAY())