Look UP certain values and then combine the rest in to one cell

[Excel Dumbo]

Hi,

Please refer the attached. I need a formual to look up certian value and then inthe following cell I would like to have to have the total of rest of the value for theat specific criteria.


Any help will be greatly appreciated. Thanks


Excel Dumbo

Look UP certain values and then combine the rest in to one cell

[Moo the Dog]

Try this...

In F2 use this formula and fill down to F4:

Please Login or Register  to view this content.

In F5 use this formula:

Please Login or Register  to view this content.

-Moo

[Excel Dumbo]

HI Moo,

Thanks for you r attention. I tried and it is giving me a #NUM error. Please see attached

[Moo the Dog]

I'm not sure why you are getting a #NUM error. I don't get one. Here is a screenshot of what I see when I open your v2 file: v2-screenshot.jpg

I have attached your original sheet with my formulas in cells F2:F4 and F5.

- Moo

[Excel Dumbo]

Hi Moo, I am using Excel 2003. I think you can't use entire columns as range references with SUMPRODUCT unless you're using Excel 2007 or later. THat is why I am getting Num# error. Not sure though

THanks for your attention and help.

[Moo the Dog]

If that is the case, then just change the formulas to:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

You can change the 1000 to whatever range height you need for your data - but make sure that all of the ranges go to the same exact height, otherwise SUMPRODUCT won't work.

- Moo