countif two columns two criteria

D

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,
 
D

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?
 
G

Gaurav

Try this

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

Doris

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

Gaurav

this one works for me

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

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.
 
Top