| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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, |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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, |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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, |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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, |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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, |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif Criteria (2 diff columns) | Excel Discussion (Misc queries) | |||
| COUNTIF with criteria in 2 columns | Excel Discussion (Misc queries) | |||
| Countif using criteria in multiple columns | Excel Worksheet Functions | |||
| Countif - Two Criteria in two columns are met. | Excel Discussion (Misc queries) | |||
| countif = < AND value in adjacent columns match criteria | Excel Worksheet Functions | |||
![Doris[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
