Excel Formula based on three criterias

I have an Excel workbook with a tab named "2015 TrialBalance" and a tab named "Sheet1". I need a fomula in 2015 TrialBalance cell G5. The formula should return the sum of Column G from Sheet1 if :  1) column B in Sheet1 is equal to 2015 TrialBalance cell $F$2  2) Sheet1column E is equal to "3952010"2015 and 3)  the name in Sheet1 column C is equal to the name in 2015 TrialBalance cell G56. Do you have a formula that can do this? Attached is a sample of the data.
SumIFS_3-three-criterias.xlsx
ConernestoAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ConernestoAuthor Commented:
Correction to my original question.

item # 2 -  2) Sheet1column E is equal to "3952010"2015 - The number 2015 after "3952010" is not needed.
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Based on your description...
Try this...
=SUMIFS(Sheet1!$G$1:$G$18,Sheet1!$B$1:$B$18,$F$2,Sheet1!$E$1:$E$18,"3952010",Sheet1!$C$1:$C$18,G56)

Open in new window

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ShumsExcel & VBA ExpertCommented:
Revised:
=SUMIFS(Sheet1!$G:$G,Sheet1!$B:$B,$F$2,Sheet1!$C:$C,$G$56)

Open in new window

10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

ConernestoAuthor Commented:
Hi, the formula is adding all the amounts from column G. I need the amounts added if column E on Sheet1 is equal to 3952010. Below is partial screen print of Sheet1. Can the formula that you sent be changed to include the condition that column E is equal to "3952010"?

10      2015      XAUS2             6150090      R00011      -39923
10      2015      XAUS2             3952010      R00047      192573
10      2015      XAUS2             3952010      R00045      451134
10      2015      XAUS2             3952010      R00034      -238210
10      2015      XAUS2             3952010      R00017      -72901
10      2015      XAUS2             3952010      R00011      -79846
10      2015      XAUS2             3952010      R00011      39923
10      2015      XAUS2             3202020      R00047      -192573
ShumsExcel & VBA ExpertCommented:
Neeraj's formula is including Col E condition.
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
@Conernesto

Did you not see the formula I posted or you ignored my answer???
ConernestoAuthor Commented:
Neeraj,

I accidently ignored your answer when I saw the next answer with the word revised. I am testing your answer as I type this reply.
ConernestoAuthor Commented:
Thank you. I will be sending a new question to include one more variable.
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.