Vlook function queri

srini_vs8562 · 22-10-2009, 05:27 PM

Dear all Excel Experts

I have used this function, i have got derieved result, When i want to total of this particular colomn result is showing 0. How do get the total. I have attached the excel file. Requet to solve this issue.
Srinivas Vayuveguala
Hyderabad
099512321510

=IF(E9>=15000,"200",IF(E9>=10000,"150",IF(E9>=8000 ,"100",IF(E9>=5000,"60",IF(E9>=3000,"30",IF(E9> =0, "0"))))))

Rashid Ahmed · 24-10-2009, 01:44 PM

Hi Srini,

Try to use SUMProduct Function--

=SUMPRODUCT((J8:J13=J8:J13)*J8:J13)

By the way I have attached your file after summarize.

Regards,

Rashid

mani.ragi · 24-10-2009, 02:25 PM

Hello Srini,

It's simple just remove the " " quotes in the formula which u have given in true value.

Eg: if(e9>15000,200,e9>10000,150........)

It works...

srini_vs8562 · 26-10-2009, 09:56 AM

To :

Dear Rashid & Dear Manikath,

A Very good morning to you both. First let me thank you very much to you both, It worked out as you said.

Thanks

Srinivas