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.

✔ 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

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

I have tried this as well but still wont pick it up either. thanks for letting me know where to post for future requests.

Not sure how your sheet is set up but for SUMIFS()

the column you want summed goes firstSUMIFS( 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

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.

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

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

Ask Your Question

Weekly Poll

Do you think Salesforce should have bought Slack?

Discuss in The Lounge

Poll History