Excel Formula - Add if three conditions are meet.

I have an Excel workbook with a tab named "EPAdjustments" and a tab named "2015 TrialBalance". I need a fomula in 2015 TrialBalance cell G14. The formula should return the sum of Column G in EPAAdjustments if 1) column B in EPAdjsutments is equal to 2015 TrialBalance cell $F$2 2) EPAAdjustments column F is equal to 2015 TrialBalance Cell $A$14 and 3)  the name in EPAdjustments 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.

Thank you.

Conernesto
SumIFS_2.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:
I will be copying the formula across for other companies that meet the criteria on my 2015 TrialBalance.
0
Ejgil HedegaardCommented:
Use this in G14 and copy across
=SUMPRODUCT(SUBSTITUTE(EPAdjustments!$G$2:$G$109,",","")*(EPAdjustments!$B$2:$B$109=TEXT($F$2,"0000"))*(EPAdjustments!$F$2:$F$109=$A$14)*(EPAdjustments!$C$2:$C$109=G56))

Open in new window

0
NorieAnalyst Assistant Commented:
There are some problems with your data, mainly that various columns, e.g. column B and G, on EP Adjustments are actually text.

You can convert those columns to 'real' numbers like this.

1 Select the column.

2 Goto Data>Text to columns...

3 Click Finish.

Once you've done that this formula should work.

=SUMIFS(EPAdjustments!$G2:$G200,EPAdjustments!$B2:$B200,'2015 TrialBalance'!$F$2,EPAdjustments!$F2:$F200,'2015 TrialBalance'!$A$14,EPAdjustments!$C2:$C200,H56)
0

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
ConernestoAuthor Commented:
Thank you very much for your help with this formula.
0
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 Office

From novice to tech pro — start learning today.