# Solved Help with excel formulas please

October 20, 2014 at 18:19:59
Specs: Windows 2010
 I am wanting to add 3 different columns but only if they are a certain number and match that number perfectly accross 2 different cells. I have tried SUMIF(E2:E108,AC44,P2:R108) this picks up the right amount but only for colomn P not accross all fields. I have also tried IF(E2:E108=AC44,SUM(P2:R108),(0)) but this adds all the colomns not separating the difference of numbers in E2:E108 with that in AC44. Your help on this one is very much appreciated.

See More: Help with excel formulas please

October 21, 2014 at 11:04:50

#1
October 20, 2014 at 18:41:02
 Look at the =SUMIFS() function, it should give you what your looking for.Also, Excel questions are best asked in the Office Software forum.MIKEhttp://www.skeptic.com/

Report •

#2
October 20, 2014 at 19:50:19
 I have tried this as well but still wont pick it up either. thanks for letting me know where to post for future requests.

Report •

#3
October 21, 2014 at 03:15:09
 Not sure how your sheet is set up but for SUMIFS()the column you want summed goes first SUMIFS( sum_range, criteria_range1, criteria1, criteria_range2, criteria2 )Column A is the column you want summed so something along the lines of::=SUMIFS(A1:A10,E1:E108,AC44,P1:P108,AC44)MIKEhttp://www.skeptic.com/

Report •

Related Solutions

#4
October 21, 2014 at 04:00:34
 I would like to add all what is in P2 up to R108 so across 3 columns, but only if they are matching to a certain cost code. For e.g. 10567 is the cost code and is in the E column and matches with AC 44 cell so I want to add up for this particular cost code along the 3 columns P2:R108. I not sure if this is possible but really appreciate your help.

Report •

#5
October 21, 2014 at 05:16:01
 Sorry, I don't understand what your looking for.Please post a small sample of your datamake sure to include Row Numbers and Column Letters.But, first read this HOW-TO, it explains the use of the PRE tags:http://www.computing.net/howtos/sho...MIKEhttp://www.skeptic.com/

Report •

#6
October 21, 2014 at 11:04:50