Excel Adjacent Cell Formula

[craigmd]

hi, what I want to do is create a chart which add the values of the number in the adjacent cells

so in the I column there would be the values of a+a, b+b, c+c

thanks : )

excel.PNG

\1

[Richard Buttrey]

Hello and welcome to the forum. Unfortunately your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Aardigspook]

Welcome to the forum and thanks for changing your thread title.

Put this in I2, dragged down to I4:

Please Login or Register  to view this content.

If you have a lot more than two columns of a/b/c and numbers, then this will get a bit unwieldy, but with just two columns it'll work fine.

[Tony Valko]

Try this...

Data Range

	A	B	C	D	E	F	G	H	I
1	------	------	------	------	------	------	------	------	------
2		A	23		C	21		A	40
3		B	34		A	17		B	79
4		C	34		B	45		C	55

This formula entered in I2 and copied down:

=SUMIF(B$2:E$4,H2,C$2:F$4)

[Aardigspook]

@craigmd: use Tony's formula - it's much easier to extend for more columns of data.

@Tony: my brain's obviously not working today

[craigmd]

thanks!

how would I put a,b,c into the formula instead of using the H column?

[AliGW]

Like this:

=SUMIF(B$2:E$4,"A",C$2:F$4)

[JohnTopley]

Unless either column B or E had A,B and C in order , not easy: how do we know the sequence?

If column B is always ascending order, replace H2 by B2

[Tony Valko]

how would I put a,b,c into the formula instead of using the H column?

I have my doubts that your REAL criteria are A, B and C.

Tell us what the REAL criteria are.

What's wrong with using cells to hold the criteria?