HELP PLEASE EXCEL!!! SUMIFS top 10 values

[mehdih]

Hi,

Trying to sum the highest volumes (column C), based on the other criterias, so let's say TYPE = B , Y OR NO = "Y" AND CLASSIFICATION = EXISTING.

Any help please? tried to use the large function but it did not work, returned 0.

Thank you

 

[alow]

Hi,

I'll see what I can do to help you out, but would you be able to list out the criteria you need, and the numbers you are trying to sum? Are you looking to sum the 10 largest numbers in column C that meet criteria in other columns? Which columns have which criteria, and what do you need to be the matching values?

Let me know and I'll see if I can put something together for you!