Forum Discussion
Kiran_gandhi610
Mar 31, 2023Copper Contributor
Need help with if formula
I have created a QA report for few employee. I need Total % in QA sheet T3 cells when I selected the No in any cell of parameter the % must decrease from the total %.
I have created a QA report for few employee. I need Total % in QA sheet T3 cells when I selected the No in any cell of parameter the % must decrease from the total %.
I think you need to reverse your thinking. Make it a matter of adding the value accorded to that column if/when you select "Yes," as is done in the attached.
Notice I put your value from the Parameters sheet along the top row of the Data sheet and used them in this SUMIF formula.
=SUMIF(E4:S4,"Yes",$E$1:$S$1)
- mathetesSilver Contributor
I have created a QA report for few employee. I need Total % in QA sheet T3 cells when I selected the No in any cell of parameter the % must decrease from the total %.
I think you need to reverse your thinking. Make it a matter of adding the value accorded to that column if/when you select "Yes," as is done in the attached.
Notice I put your value from the Parameters sheet along the top row of the Data sheet and used them in this SUMIF formula.
=SUMIF(E4:S4,"Yes",$E$1:$S$1)
- Kiran_gandhi610Copper ContributorThank you so much sir