LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Junior Member
 
Posts: 19
Default

Quote:
Originally Posted by Spencer101 View Post
Either of the following will do the trick.

=SUMPRODUCT((A1:A6="Dog")*(B1:B6=0))

=COUNTIFS(A1:A6,"Dog",B1:B6,"=0")


COUNTIFS can only be used in Excel 2007 or later.


Thanks for the reply. I forgot about a 3rd column that also needs to be looked at. The third column will have colors, i.e Black, White, Two Tone etc.

This would also for part of the count criteria. In some instances I want to have multiple colors added, i.e Beige, Brown.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
countif with a condition and contains @ Pete_UK Excel Worksheet Functions 1 March 18th 10 09:15 AM
countif where condition should be met SCC Excel Worksheet Functions 3 September 28th 09 08:47 PM
COUNTIF - Condition Sandesh Excel Discussion (Misc queries) 7 August 24th 08 08:58 AM
COUNTIF - more than one condition Gary Excel Worksheet Functions 4 May 8th 07 08:46 PM
How do I set up a COUNTIF with more than one condition? Gail Excel Programming 4 September 1st 06 08:23 PM


All times are GMT +1. The time now is 04:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"