Posted to microsoft.public.excel.misc

Gingit

Posts: n/a

Sumproduct and horizontal lookup

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
using sumproduct	Jakobshavn Isbrae	Excel Discussion (Misc queries)	2	June 11th 06 01:11 AM
How can I use SumProduct with a horizonontal and vertical array?	issy	Excel Discussion (Misc queries)	3	May 25th 06 09:41 AM
HORISONTAL AND VERTICAL AREA IN SUMPRODUCT	emilija	Excel Worksheet Functions	1	May 4th 06 01:20 PM
sumproduct w/horizontal range not working	dcd123	Excel Worksheet Functions	6	August 22nd 05 11:48 PM

All times are GMT +1. The time now is 12:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us