CODEWITHSUNDEEP
excelexcel-formula
JonhDoe
JonhDoe

Reputation: 33

Excel - Sum between dates according to criteria and user input

Need help figuring out how do I sum all the values inside a certain criteria and a user input date. Assuming that the criteria is 115 how do I add to the function the capabilty to sum according to a date range of choice?

I can get the criteria sum just fine with =SUMIFS(B2:B21;C2:C21;"115") but i cant figure out something to add the date to this function.

Table Example

Any help is aprecciated! Thanks in advance!

JonhDoe

Upvotes: 2

Views: 64

Answers (1)

Scott Craner
Scott Craner

Reputation: 152505

Use:

=SUMIFS(B:B;C:C;"115";A:A;">=" & E3;A:A;"<=" & E5)

NOTE

This assumes that the "Dates" in column A are in fact true dates and not strings that look like dates. It appears that your "numbers" are stored as text.

Upvotes: 1

Related Questions