Question Me & Rate...!
Finance & Accounts
+1 Other

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
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

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

Attached Files
File Type: xls excel if function.xls (16.5 KB, 6292 views)

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

Attached Files
File Type: xls excel if function.xls (28.5 KB, 1932 views)

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...
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
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2020 Cite.Co™