Excel - How to SUMIF Between Two Dates in a Range - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I am trying to utilize a complicated sumif or sumifs formula that can pull a total amount from a date and a drop down box from another tab.
Solved by E. B. in 15 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 12/02/2018 - 06:18
Helloo
User 12/02/2018 - 06:19
Hello I am trying to get the sum in row 12 column H
Excelchat Expert 12/02/2018 - 06:19
Can you please provide details of the sumif problem?
User 12/02/2018 - 06:19
From an EFT drop down box
User 12/02/2018 - 06:19
from the date 2/9/18 in tab 2
User 12/02/2018 - 06:20
Based on the posted date
Excelchat Expert 12/02/2018 - 06:21
the sum should be on Sheet2?
User 12/02/2018 - 06:21
Well kind of
User 12/02/2018 - 06:21
There are multiple cells in sheet 2
User 12/02/2018 - 06:21
that equal what I need which I want on sheet 1
User 12/02/2018 - 06:22
So any drop down box called 'EFT" ON 2/9/18 I want the sum of
Excelchat Expert 12/02/2018 - 06:22
what are the criteria?
User 12/02/2018 - 06:23
so 43670.57 should appear in H 12 on sheet 1
User 12/02/2018 - 06:23
well no
Excelchat Expert 12/02/2018 - 06:23
sum should be calculated from from column B? in sheet2 with matching date as 2/9/2018 and Trans Type as ETF
User 12/02/2018 - 06:24
close
User 12/02/2018 - 06:24
It should be based on the posted date
User 12/02/2018 - 06:24
so column D
User 12/02/2018 - 06:24
and column E
User 12/02/2018 - 06:24
based on G
Excelchat Expert 12/02/2018 - 06:25
in column D we have number not date..
User 12/02/2018 - 06:25
yep
User 12/02/2018 - 06:25
so I need the sum of those numbers
User 12/02/2018 - 06:25
if they have a date of 2/9/18 and is an EFT
User 12/02/2018 - 06:26
in cell H 12 on sheet 1
Excelchat Expert 12/02/2018 - 06:27
for the current criteria you mentioned the sum is 42170.57
Excelchat Expert 12/02/2018 - 06:28
is this correct?
User 12/02/2018 - 06:28
43670.57
Excelchat Expert 12/02/2018 - 06:28
yes.. please check the formula on the sheet..
User 12/02/2018 - 06:29
you got it!!
Excelchat Expert 12/02/2018 - 06:29
:)
Excelchat Expert 12/02/2018 - 06:29
marking the session as done..
Excelchat Expert 12/02/2018 - 06:30
do you want me to explain the formula?
User 12/02/2018 - 06:30
yes please
Excelchat Expert 12/02/2018 - 06:31
SUMIFS . formula is used when we work with multiple criteria..
Excelchat Expert 12/02/2018 - 06:31
in this case we are calculating sum of Column D in sheet 2 with ...
User 12/02/2018 - 06:32
okay gotcha
User 12/02/2018 - 06:33
you rock :)
Excelchat Expert 12/02/2018 - 06:33
Thanks..
User 12/02/2018 - 06:33
Please give me your brain
User 12/02/2018 - 06:33
lol have a good day
Excelchat Expert 12/02/2018 - 06:33
please leave feed back when you close the session..

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.