countif Column A and excule column B if it's cancelled
that formula works great - thanks.
I have a column C now that has the revenue amount. how would I do the
formual to add up the revenue of only the projects for that project type that
aren't cancelled?
thanks again
"bj" wrote:
try = sumproduct(--(A1:A64000="Home"),--(B1:B64000<"Cancelled"))
a specific range must be specified and not an entire column
"LLWest" wrote:
I have a spreadsheet that has column A with project type and column B with
the status. I need to count all projects of a certain type in column A that
do not have a status = Cancelled in column B. The formulas as in another
worksheet.
I've been trying to use this formula but it's not correct:
=COUNTIF(Projects!$A:$A,"Home")-COUNTIF(Projects!$B:$B,"Cancelled")
I'm not sure if Countif is the right function to use. would Sumproduct be
better?
|