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.


"Gaurav" wrote:

this one works for me

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



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



"Gaurav" wrote:

Try this

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


"Doris" wrote in message
...
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" wrote:

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

"Doris" <Doris @discussions.microsoft.com wrote in message
...
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,