Calculating frequency in two columns

  • Thread starter Thread starter excelmedia
  • Start date Start date
E

excelmedia

Hello!

Here is my problem

Column A has name of Item e.g: Mag 1, Mag 2, Mag3
Column B has Colour of Item e.g Blue & Green
Column C Has frequency of Item e.g. 3, 4, 5 i.e.3 Mag1's were Blue


I need to know how many times each individual item was blue.

Pls Help
 
Hi
one solution:
=SUMPRODUCT((A1:A999="Mag 1")*(B1:B999="Blue")*(C1:C999))
will return the number of blue Mag 1 items

another idea would be to use Pivot tables

HTH
Frank
 
excelmedia > said:
Hello!

Here is my problem

Column A has name of Item e.g: Mag 1, Mag 2, Mag3
Column B has Colour of Item e.g Blue & Green
Column C Has frequency of Item e.g. 3, 4, 5 i.e.3 Mag1's were Blue


I need to know how many times each individual item was blue.
Click to expand...

Use formulas such as this:
=SUMPRODUCT((A1:A99="Mag1")*(B1:B99="Blue")*(C1:C99))
 
Back
Top