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