countif two columns two criteria

[Doris]

I want to count the pending sales in column "C' if they are "COM" in column
"O".
The status column and type column for sales in a spreadsheet.

TIA,

 

[Gaurav]

=SUMPRODUCT(--(C1:C10="pending")*(O1:O10="COM"))

 

[Doris]

The two columns are on a different sheet in a workbook.
I tried =SUMPRODUCT(--(VE-EGC-CSS-DUKE(C:C="pending")*(O:O="COM")) but
didn't work?

 

[Gaurav]

Try this

=SUMPRODUCT(--(VE-EGC-CSS-DUKE!C1:C5000="pending")*(VE-EGC-CSS-DUKE!O1:O5000="COM"))

 

[Doris]

No, it brought up the saveas dialog box and when I cancelled that #NAME? in
in the cell.

 

[Gaurav]

this one works for me

=SUMPRODUCT(--(Sheet1!C1:C10="pending")*(Sheet1!O1:O10="COM"))

 

[Doris]

But the formula is on sheet2 next to COM, for the total number of Com sales.

COM
122

RES
156

I've alway used countif but not we are selling commercial & residential and
they are mixed. I want to deplay the totals on another sheet.