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

If condition problem
Available memory less than 15mb condition zero - Guide
If condition in excel - Guide
Conditional formatting if two cells match ✓ - Excel Forum
Vba copy data from one sheet to another if a condition is met - Excel Forum
Your phone is optimal condition meaning - Guide

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?

Excel - IF function with multiple words

Highlight cell if another cell contains specific text

Merge rows if it meets criteria in Excel

Highlight cell if another cell contains any text

Similar discussions

Subscribe To Our Newsletter!