Hi- I saw the answer you provided to Michelle and I have a similiar problem.
A B C
1 .5 Completed ? (need to equal total hours completed)
2 1.0 Completed
3 4.5 Not Started

i need a formula that will return the sum of column A in Column C, only if
Column B contains text "completed" , If not, no value is returned in C.
hope that makes sense! I know this is simple, but I keep getting an error.


"Max" wrote:

Perhaps ..
Put in D1: =IF(OR(B1="",C1=""),"",IF(B1=C1,A1,0))
Copy D1 down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"michelle" wrote:
a b c d
1 .2 yes yes .3
2 .5 no no .5
3 .1 yes maybe 0

So, as in the above example, I need to put a formula in D1 so that it will
take the sum of column a if column b = c1. I hope this makes sense. And
keep in mind I will be continually adding rows to this and will need it to
cover the entire row, not just part of a row.

Thank you in advance and let me know if you need more clarification.