Cse formula to do conditional sum w/large function to get a top10

**carlosmaldonado** · 09-13-2013, 07:54 AM

As I've searched and I didn't found noting like I need, I decided to appeal your help.

The aim is to do a CSE formula wich contains the multconditional sum (this one I know how to do it), but I need to include the LARGE function, as I need to rank a top 10 highest stock values, by month, by business area, by material code, summing the column with the stock value in each line.

This will give me the top 10 items which have the highest value per each business area, each month.

What I have in terms of CSE formula to do multiconditional sum is:

SUM(IF((DATA!$AR:$AR="RMV")*(DATA!$AO:$AO="AGO13");DATA!$AU:$AU)) This formula is done over the attached file.

Regards
Carlos

**carlosmaldonado** · 09-13-2013, 10:17 AM

pls guys, help is needed!

**DBY** · 09-13-2013, 12:30 PM

Hello
This Array formula (CSE) sums the 10 largest values that meet the criteria:

Please Login or Register  to view this content.

Is this what you require?

Note it's probably not a good idea to reference entire columns with these formulas as in your example.

DBY

**carlosmaldonado** · 09-13-2013, 03:27 PM

Hi DBY,

isn't working, cause the highest value is to rank the material code (in column E), that's the array which is missing into the LARGE function.

The aim is get the top 10 materials with the highest value in the overall stock of one business area, each month.

Regards
CMP

**DBY** · 09-15-2013, 10:50 AM

Hi
Sorry. From your example formula I was under the impression that the criteria was: "RMV" and "AGO13" in columns AR, AO respectively and summing AU. Are you saying you want to sum the top ten of each Material Code (Nº Produto)? The Material Codes themselves can't be ranked as they're entered as text.

DBY

Cse formula to do conditional sum w/large function to get a top10

LinkBack

Thread Tools

Rate This Thread

Display

Cse formula to do conditional sum w/large function to get a top10

Re: Cse formula to do conditional sum w/large function to get a top10

Re: Cse formula to do conditional sum w/large function to get a top10

Re: Cse formula to do conditional sum w/large function to get a top10

Re: Cse formula to do conditional sum w/large function to get a top10

Thread Information

Users Browsing this Thread

Similar Threads

Conditional Large Formula

Conditional Formatting with LARGE formula not working

Extract TOP10 of values

[SOLVED] AutoFilter Top10 not working

Conditional Formula to Give the Large Number

Bookmarks

Bookmarks

Posting Permissions