Solved

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

Posted on 2016-10-27
5
41 Views
Last Modified: 2016-10-27
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
Comment
Question by:Ryan Simmons
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 23

Expert Comment

by:NBVC
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

by:Ryan Simmons
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

by:
NBVC earned 500 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

by:Yamaafg
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

by:Ryan Simmons
ID: 41862781
Perfect, ty!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question