I have colum b2:b113 ( named cell range as owner) and colum c2:c113 (named cell range as status), I have to add data based on the name of the owner and the under the status of the owner.
e.g.
Owner Status
john Active
john Canceled
john Cancelled
john Active
Al Active
Frank Active
I am using the formula =sumproduct((owner="john")*(status="Cancelled"))
but it doesn't seem to be working. I have also tried it without the named range and just entering the cell range manually b2:b113 and still it doesn't work. Can some one please help me figure out another way to do this.
e.g.
Owner Status
john Active
john Canceled
john Cancelled
john Active
Al Active
Frank Active
I am using the formula =sumproduct((owner="john")*(status="Cancelled"))
but it doesn't seem to be working. I have also tried it without the named range and just entering the cell range manually b2:b113 and still it doesn't work. Can some one please help me figure out another way to do this.