**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.*