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