L
Luis
I have two columns of data. One of the columns lists sources by which
customers heard of our company. Another contains the status of the
appointment. Ex:
COLUMN A COLUMN B
Yellow Pages LOST
Radio SOLD
Truck Signs SOLD
Yellow Pages LOST
Yeloow Pages SOLD
etc......
I want to take a count of how many times an appointment from a certain
source is sold. In other words, I need it to meet both criteria. I've
tried using the COUNTIF function but can't seem to work it out. I've
looked through other postings and tried
=SUMPRODUCT((Sheet1!A:A="Yellow Pages")*(Sheet1!B:B="Sold"))
but that gives me the error #NUM!
Thanks in advance.
customers heard of our company. Another contains the status of the
appointment. Ex:
COLUMN A COLUMN B
Yellow Pages LOST
Radio SOLD
Truck Signs SOLD
Yellow Pages LOST
Yeloow Pages SOLD
etc......
I want to take a count of how many times an appointment from a certain
source is sold. In other words, I need it to meet both criteria. I've
tried using the COUNTIF function but can't seem to work it out. I've
looked through other postings and tried
=SUMPRODUCT((Sheet1!A:A="Yellow Pages")*(Sheet1!B:B="Sold"))
but that gives me the error #NUM!
Thanks in advance.