EXCEL - help to sum a column based on information from another column (Conditional Sum?)

tmajor99
tmajor99 used Ask the Experts™
on
Need help with an EXCEL formula.  I need could from one column based on an answer fro another column.  For example; I need to count all the estimated hours for Phase II.  Phase II is indicated by "Yes" in the Phase II column.  

EXCEL File:
Estimate        Phase II
------------         -----------
30                     No
40                     Yes
60                     Yes
42                     No

Subtotal for Phase II = 100
Subtotal for Phase I = 72
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Group Finance Manager
Commented:
Do you mean SUMIF?
SUMIF-2-.xlsx
Roy CoxGroup Finance Manager

Commented:
Pleased to help

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial