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?
- combining formula
- formula help but not vba please
- Need to delete a row in excel based on user input
- Loop in formula
- Formula using range name in VBA code
- Populate Formula(Function) in rows
- Three Leveled Formula
- Help Needed on This Excel Problem
- R1C1 Formula
- Paste Formula help
- Code needed from within Excel to lookup info from Outlook Addressbook
- VBA or array formula?
- VBA code to add values in two cells which have formulas
- How to add several conditions for formula "SUMIF"
- Help needed for a VBA novice with excel charting
- VBA Formula prob
- Getting a formula to copy from inside VBA
- searching within formulas
- Excel Macro Help Needed
- Quotations in Formulas and strings
- Manually creating a row outline with no formula anywhere