if condition problem Closed

Question

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

Trowa · Answer

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

If condition problem

1 response

Similar discussions

Subscribe To Our Newsletter!