Previous Topic Next Topic

If condition problem

Closed
Najaf - Jul 28, 2009 at 08:48 AM
 Trowa - Jul 30, 2009 at 07:14 AM
Hello,
i need to use an if condition function formula but i have a problem using that of my huge data base

my formula is

=IF(F12=D5,H12,0)+IF(F13=D5,H13,0)+IF(F14=D5,H14,0)+IF(F15=D5,H15,0).......


is there any other way to get the result without typing it (i have almost more that 2500 raws and exceeds)

i need your openion please

1 response

Answer 1 / 1
Trowa
Jul 30, 2009 at 07:14 AM
Hi Najaf,

Use your most right column to enter your IF function separatly.

So in cell I12 you put: =IF(F12=$D$5,H12,0)

Now drag your formula down.

At the bottom insert the sum function: =SUM(I12:I2512)

Let me know how this works out for you.

Best regards,
Trowa

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Copying cells if condition is met
QuestionAsker2525 -
ac3mark -

1 response