HELP PLEASE EXCEL!!! SUMIFS top 10 values

M

mehdih

Joined
Sep 9, 2014
Messages
1
Reaction score
0
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
 
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!
 
Back
Top