CODEWITHSUNDEEP
excel
Lererferler
Lererferler

Reputation: 297

Excel Sumifs with reference to a cell

I want to use the sumifs formula to sum a date range but with a variable date as a reference to a cell ie something along the lines of

=SUMIFS(Database[Daily Commission],Database[Date],>E2)

So I want to sum the daily commission where the date is greater than the date in E2. Anybody have any ideas?

Upvotes: 0

Views: 713

Answers (1)

tea_pea
tea_pea

Reputation: 1542

=SUMIFS(Database[Daily Commission],Database[Date],">"&E2)

Upvotes: 1

Related Questions