Count matching cells

  • Thread starter Thread starter Ted D
  • Start date Start date
T

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")*
(D3:D80="Grey","White"))

Thanks for any help
 
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.
 
I think I got it, can you tell me if there is an easier
way?
Just an example
=SUMPRODUCT((B2:B80="blue")*(D2:D80="apples")) +
(SUMPRODUCT((B2:B80="blue")*(D2:D80="oranges")))
 
Your Original Request would be handled by entering:
=SUMPRODUCT((B3:B20="Blue")*((D3:D20)={"Grey","White"}))
Give that a try..
HTH
 
Back
Top