# 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
###### Who is Participating?

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.

Author Commented:
Correction to my original question.

item # 2 -  2) Sheet1column E is equal to "3952010"2015 - The number 2015 after "3952010" is not needed.
Excel & VBA ExpertCommented:
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)
``````

Experts Exchange Solution brought to you by

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

Excel & VBA ExpertCommented:
Revised:
``````=SUMIFS(Sheet1!\$G:\$G,Sheet1!\$B:\$B,\$F\$2,Sheet1!\$C:\$C,\$G\$56)
``````
Author 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
Excel & VBA ExpertCommented:
Neeraj's formula is including Col E condition.
Excel & VBA ExpertCommented:
@Conernesto

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