x
Solved

# How can I use SUMIF to find the data from previous week?

Posted on 2016-10-27
Medium Priority
63 Views
Example Dataset attached. How can I use SUMIF to find the number from column B from the previous week which is A2-7?
Example.xls
0
Question by:Ryan Simmons
• 2
• 2

LVL 23

Expert Comment

ID: 41862712
You have a formula there that seems to be the correct one based on your question.

Why do you think it is not working?  Apr 2, 2016 shows up multiple times in column A so you are getting a sum of all those times.
0

Author Comment

ID: 41862740
Ah... you are right. So how can I get the SUMIF to accept a second criteria? Basically there are stores and I only need the demand for one store for previous week. Second example attached.
Example-2.xls
0

LVL 23

Accepted Solution

NBVC earned 2000 total points
ID: 41862747
You can use SUMIFS

e.g.

=SUMIFS(C:C,A:A,A2,B:B,B2-7)

notice the range to sum is at the front now...followed by the criteria ranges and criterias
0

LVL 5

Expert Comment

ID: 41862773
Hi, try below array formula, remember to press Ctrl+shift+enter

=SUM(IF((\$A\$2:\$A2>=(\$A2-6))*(\$A\$2:\$A2<=\$A2), \$B\$2:\$B2, 0))
0

Author Closing Comment

ID: 41862781
Perfect, ty!
0

## Featured Post

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.