We help IT Professionals succeed at work.

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.
Comment
Watch Question

Finance Analyst
Commented:
You need the SUMIF function.

=SUMIF(E5:E150,"Yes",F5:F150)

That says, look in E5:E150 and where its is equal to "Yes" include value from equivalent cell in F5:F150
byundtMechanical Engineer
Most Valuable Expert 2013
Top Expert 2013
Commented:
Use SUMIF for this purpose:
=SUMIF(E5:E150,"Yes",F5:F150)

Open in new window

Bill GoldenExecutive Managing Member

Author

Commented:
Lightning FAST and Perfect! Thanks...
Bill GoldenExecutive Managing Member

Author

Commented:
Thanks again.