I have the following spreadsheet:
A B C D
1 Jan Feb
2 blue 50 30
3 red 125 544
4 yellow 40 44
5 blue 30 122
6 red 54 60
7 red 100 80

How do I use sumproduct with a lookup in the colums. For ex. I want to know
how much I have in the blue for Jan and Feb. I don't won't to use pivot
tables.

Thanks Gingit.