I need an excel formula
- or -
Post a project like this3343
$30
- Posted:
- Proposals: 18
- Remote
- #672741
- Awarded
PowerPoint and Excel Specialist, Data Entry, Web Research, Excel Dashboard, Excel Automation
New Delhi
Graphic Designer | Social Media Post Designer | Menu Cards Designer | Logo Designer | Poster Designer
North Karachi
74984686733963734867045866573866030865054863829840502800218735997664984
Description
Experience Level: Entry
Estimated project duration: 1 day or less
I have a reference row of values: 1 4 E 5 1 E 3
I have a row underneath of binary corresponding to yes and no: 1 0 0 1 1 1 0
I need a formula that sums all of the top row values that correspond to a 1 on the row below except when any E is 0 in which case the out put should be 0. the final result should be a percentage value. I am very keen on avoiding VBA and any additional columns if possible. reference table values should be editable I can send excel for further discussion but need email address. this is urgent. thanks
I have a row underneath of binary corresponding to yes and no: 1 0 0 1 1 1 0
I need a formula that sums all of the top row values that correspond to a 1 on the row below except when any E is 0 in which case the out put should be 0. the final result should be a percentage value. I am very keen on avoiding VBA and any additional columns if possible. reference table values should be editable I can send excel for further discussion but need email address. this is urgent. thanks
Michael C.
100% (2)Projects Completed
4
Freelancers worked with
3
Projects awarded
50%
Last project
3 Apr 2017
Indonesia
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies