IF OR SUMIF OR SUMTHING ELSE

[Dunc]

Sorry about the subject title for all you searching but I couldnt summarise it. (in fact im having difficulty explaining it)

I would like the formula

IF the text of a cell in column D = "STRING" THEN its corresponding cell in column C should be added to the cell where the formula is.

With Kind Regards


Duncan
This message was edited by Dunc on 2002-10-25 13:01

 

[Dave Patton]

On 2002-10-25 12:52, Dunc wrote:
Sorry about the subject title for all you searching but I couldnt summarise it. (in fact im having difficulty explaining it)

I would like the formula

IF the text of a cell in column D = "STRING" THEN its corresponding cell in column C should be added to the cell where the formula is.

With Kind Regards


Duncan

Hello Duncan

What happened when you used Sumif?

SUMIF(range,criteria,sum_range)

You could show an example of your formula.

 

[Andrew Poulsom]

??

=IF(D1="STRING",C1&D1,"")

EDIT On second thoughts:

=YourFormula+IF(D1="STRING",C1,0)
This message was edited by Andrew Poulsom on 2002-10-25 13:08

 

[Dunc]

On 2002-10-25 13:04, Andrew Poulsom wrote:
??

=IF(D1="STRING",C1&D1,"")

EDIT On second thoughts:

=YourFormula+IF(D1="STRING",C1,0)
This message was edited by Andrew Poulsom on 2002-10-25 13:08

Andrew I appreciate your response and from now on I will write the formulas that I have tried because then you would have known that I had already worked out how to do it on a cell per cell basis what I was actually looking for was a single formula that would do exactly the same for all cells in column. (dynamically)

Again Kind Regards

Duncan

 

[Andrew Poulsom]

So is your problem solved?

 

[Aladin Akyurek]

Do you mean literally the word STRING or any string?

 

[Dunc]

Sorry Andrew I have been so busy I have not had time to review the posts. Yes that worked on a cell per cell basis but not on a column basis. Does this make sense?

 

[Dunc]

No I mean a specific string ie: string = "myname"

 

[Andrew Poulsom]

Please post a sample of your data and the expected results.

 

[Dunc]

I would ultimately like to have the formula tocalculate for a column not a cell.

dunc.xls
	A	B	C	D	E	F
1	product	date	debit	credit	purchased
2
3	1-Jan-02
4
5	hammer	1/1/2002	1.00		diyshop
6	nails	1/1/2002	2.00		diyshop
7	teabags	1/2/2002	0.50		cornerstore
8	milk	1/3/2002	0.30		farmer
9
10	1-Feb-02					1.00
11
12	coffee	2/1/2002	1.00		diyshop
13	mortgage	2/1/2002	10.00		thebank
14	plasters	2/2/2002	0.75		hospital
15	sand	2/3/2002	3.00		diyshop
16	cement	2/4/2002	1.50		diyshop
ademo