Excel Help Needed: Why Is My Column Total Showing as Zero Despite Using IF Function?

Dear all Excel Experts,

I have used this function and obtained the derived result. However, when I try to calculate the total of this particular column, the result is showing as 0. How can I get the correct total? I have attached the Excel file. Request your assistance in resolving this issue.

Srinivas Vayuveguala
Hyderabad
099512321510
[Login to view]

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

Hi Srini,

Please try using the SUMPRODUCT function as follows:
=SUMPRODUCT((J8:J13=J8:J13)*J8:J13)

By the way, I have attached your file after summarizing it.

Regards,
Rashid

Hello Srini,

It's simple, just remove the quotes in the formula which you have provided in the true value.

For example: if(e9>15000,200,e9>10000,150........) It works...