Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...
MS Office Forum / Excel / Worksheet Functions / May 2008

Tip: Looking for answers? Try searching our database.

countif two columns two criteria

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Doris - 05 May 2008 14:43 GMT
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 to this Message
Gaurav - 05 May 2008 14:55 GMT
=SUMPRODUCT(--(C1:C10="pending")*(O1:O10="COM"))

>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 to this Message
Doris - 05 May 2008 16:25 GMT
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?

> =SUMPRODUCT(--(C1:C10="pending")*(O1:O10="COM"))
>
[quoted text clipped - 3 lines]
> >
> > TIA,
Reply to this Message
Gaurav - 05 May 2008 17:25 GMT
Try this

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

> 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
[quoted text clipped - 8 lines]
>> >
>> > TIA,
Reply to this Message
Doris - 05 May 2008 17:45 GMT
No, it brought up the saveas dialog box and when I cancelled that #NAME? in
in the cell.

> Try this
>
[quoted text clipped - 12 lines]
> >> >
> >> > TIA,
Reply to this Message
Gaurav - 05 May 2008 17:53 GMT
this one works for me

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

> No, it brought up the saveas dialog box and when I cancelled that #NAME?
> in
[quoted text clipped - 16 lines]
>> >> >
>> >> > TIA,
Reply to this Message
Doris - 05 May 2008 19:44 GMT
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.

> this one works for me
>
[quoted text clipped - 20 lines]
> >> >> >
> >> >> > TIA,
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.