# 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
###### 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:
I will be copying the formula across for other companies that meet the criteria on my 2015 TrialBalance.
0
Commented:
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))
``````
0
Analyst 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.

0

Experts Exchange Solution brought to you by