Dear Subu, This can be accomplished with Sumproduct function. Please send a sample sheet, I can work it out for you.
Regards, Andy On Sun, May 31, 2009 at 7:40 PM, Subu <mail_to_s...@yahoo.com> wrote: > > Dear Members > > > 1. I have a table with columns A, B, C, D, E, F,.... > > 1.1. Column A has the range of values to be be evaluated and Columns > D,E,F,...have the sum range (values that need be summed up based on > criteria) > > 1.2. If I just had one criteria I could use sumif function. say sumif > (A:A,"ABC",D:D) > > 1.3. However, I wish to sum values in columns D,E,F, based on a range > of criteria ..something like if colums A = TEXT(ABC) or TEXT(DEF) or > XYZ, sum columns D, ...etc ... > > ... i.e. not just one criteria or one value, but a range of criteria > > 1.4. How do I achieve this ? > > 2. In the same scenario, is it possible to list one line of sum per > criteria ? > > Thanks in advance > Best regards > Subu > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
