Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

Can anyone help me figure out a formla that has a similar index match function,

but instead of picking the first selection of a repetitive item in the list,

itwouldsum the repetitive item in the total calculation. Please note

I'm not looking for a sumif formula, see example below.

Fig 1) source data

name units net rev

bear 1 1

10.00

bear 2 1

15.00

bear 1 2

20.00

Fig 2)

Report:

bear

1 bear 2

Unit

3 1

net rev 30.00 15.00

Fig 2 is the template that Ineedcreate a formula using one lookup

function that wouldmatchheadersacross the columns and

rowsdown the list.

Actually my data source is very large and it takes several sumifs and several

look up to pull in the report. Is there a one formula solution that can

accomodate all this pull?

I'll appreciate the help.

Use a pivot table..............................

if you are not looking for Sumif formula then Use

array Function In Excel

I'm not familiar with array functions. I did use the pivot table and it worked, but I guess if would me more effective in my case if

you show me how to write an array formula.

Didn't find what you were looking for?
Find more on Need of an Excel Formula
Or get search suggestion and latest updates.

Related Topics:

- copy down formulas in excel
- pasting word table to Excel but needing to match excel
- Need Help In Deleting Duplicate Items in Excel a excel file
- clearing cells value without deleting the formula I've made in cell from excel formula , HOW?
- Need to delete a row in excel based on user input
- Help Needed on This Excel Problem
- Code needed from within Excel to lookup info from Outlook Addressbook
- Help needed for a VBA novice with excel charting
- Excel Macro Help Needed
- need vba excel code
- Help needed in SQL to Excel VBA Form
- Excel VBA - need to copy paste conditional statement
- Need to split up Excel File to multiple CSV files bases on column
- Need Help in Excel-VBA
- Need Excel VBA Help with deleting rows
- Need to import information from a Word File Into Excel
- need help in excel
- Excel help needed...
- Need to move Word content to Excel
- Automatically apply specific formulas to specific columns
- Using an array formula as a hyperlink cell reference
- VBA variable range in a formula
- Formula multiplying ActiveCell with "F11"
- Romberg's intigration formula.
- formula returns to multiple cells, without Array object?