Sum IF Help

[ScabbyDog]

In range B2:XJD25 I will have cells that contain the word "Done". I need a formula that finds all instances of "Done" and when found sum the numbers that are found directly to the right of the cell (cells to the right of "Done" will always contain a number)

[etaf]

use a SUMIF()

=SUMIF( range with the word done in ,"done" , range you want to sum)

[ScabbyDog]

use a SUMIF()

=SUMIF( range with the word done in ,"done" , range you want to sum)

That won't work as the formula would look like:

Please Login or Register  to view this content.

And that would be too many arguments for excel to handle and it throws an error. I'd actually be working with 10000 columns but made that formula much less.

[etaf]

why would it look like that

can the word done be in any column and you want the cell to the right - then sumif() will not work
I suspect you need VBA , not my area of expertise

[ScabbyDog]

It'd look like that because that's the way you have to enter the formula....

Done can be in any column yes. I'll ask on VBA forum so. Thanks for trying anyway.

[etaf]

It'd look like that because that's the way you have to enter the formula....

not quite

but it does need the columns to be the same

if done was somewhere in column B and the value in column G

=sumif( b2:b25, "done" , g2:g25) is how the SUMIF() works

[ScabbyDog]

As previously stated though, "Done" can be anywhere. Otherwise you're right - it'd just be a simple SUMIF formula. I'll close the thread.

[AlKey]

Here is a sample that you may be able to adapt
formula in A2

Please Login or Register  to view this content.

v	A	B	C	D	E	F	G	H
1
2	134	Done						25
3				Done		Done		32
4						Done		45
5								51
6

[Tony Valko]

As previously stated though, "Done" can be anywhere. Otherwise you're right - it'd just be a simple SUMIF formula. I'll close the thread.

Like this...

Data Range

	B	C	D	E	F	G
2	Done	48	Blah	Done	100	94
3	Blah	55	Blah	39	Blah	68
4	Blah	Done	100	92	Done	63
5	Blah	46	Blah	42	Done	59
6	------	------	------	------	------	------
7
8
9	370

=SUMIF(B2:F5,"Done",C2:G5)