countif two columns two criteria
 

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,

countif two columns two criteria
 

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

countif two columns two criteria
 

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,

countif two columns two criteria
 

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,

countif two columns two criteria
 

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,

countif two columns two criteria
 

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,

countif two columns two criteria
 

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,