asked on Totalling a column of cells based on Yes/No value in corresponding cells.
In Excel, I have a column of numbers, F5 through F150. Each line has Yes or No in Column E. I want to take a total in cell F151 of all cells (F5 through F150) in which a Yes appears in the corresponding cell in Column E.
Microsoft ExcelMicrosoft Office
Last Comment
Bill Golden
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Lightning FAST and Perfect! Thanks...
ASKER
Thanks again.