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.