KyleOliver
New Member
- Joined
- Apr 16, 2016
- Messages
- 31
Hi clever Excel people;
I have a drop down menu in column B which returns a "yes" or "no" only.
if "yes" or "no" in Column B is selected (it does not matter what drop down answer you select) and column C is "yes" the value 01 must be added to column E.
I have tried SUMPRODUCT and SUMIF but I keep getting an error.
Please help.
Regards
I have a drop down menu in column B which returns a "yes" or "no" only.
if "yes" or "no" in Column B is selected (it does not matter what drop down answer you select) and column C is "yes" the value 01 must be added to column E.
I have tried SUMPRODUCT and SUMIF but I keep getting an error.
Please help.
Regards