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

Report •


✔ Best Answer
October 21, 2014 at 11:04:50
valziemick2207,

Try this...

=SUMPRODUCT($P$2:$R$108*($E$2:$E$108=AC44))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03



#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.

MIKE

http://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)

MIKE

http://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 data
make 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...

MIKE

http://www.skeptic.com/


Report •

#6
October 21, 2014 at 11:04:50
✔ Best Answer
valziemick2207,

Try this...

=SUMPRODUCT($P$2:$R$108*($E$2:$E$108=AC44))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •

Ask Question