Count matching cells

[Ted D]

Hello, This is just an example: I am trying to count the
cells say B3:B80= blue, but also has d3:d80= grey or
white. This will be a template so items in column B and D
can get rearranged. What kind of formula would I use for
this? I tried several, but when I try to use the second
criteria it won't work. ie. =SUMPRODUCT((B3:B80="blue")*
(D380="Grey","White"))

Thanks for any help

 

[JMay]

Go to: http://www.cpearson.com/excel/colors.htm

 

[Ted D]

Thanks for the quick response. However, I was just using
the colors as an example. The cells will actually have
text in them ie. B3:B80 apples/blue/grapes etc. and
D3:d80 will have text as well table/chairs/white I know
it sounds weird, but I just need a formula that looks at
column B and if the requirement is there than compare it
to column D and count the number of multiple requirements
I request for that column. Hope that makes it any clearer.

Thanks for any input.

 

[Aladin Akyurek]

=SUMPRODUCT((B3:B80="blue")*(D380={"Grey","White"}))

 

[JMay]

Sorry, but I too quickly scanned your request.
Aladin didn't -- fortunately...

 

[TED D]

I think I got it, can you tell me if there is an easier
way?
Just an example
=SUMPRODUCT((B2:B80="blue")*(D280="apples")) +
(SUMPRODUCT((B2:B80="blue")*(D280="oranges")))

 

[JMay]

Your Original Request would be handled by entering:
=SUMPRODUCT((B3:B20="Blue")*((D320)={"Grey","White"}))
Give that a try..
HTH