Combining COUNTIFS with VLOOKUP?

So what does your expected output look like?

I have one idea, but I dont want to waste time on it if you want the output to look like something else.

this could work for you, adjust for each range as needed...
=SUMPRODUCT(($C$2:$C$123>=0)*($C$2:$C$123<=0.05))

And this (adjust again for ranges) for your negatives....
=SUMPRODUCT(($C$2:$C$123<=0)*($C$2:$C$123>=-0.05))

An example of what you want the results to look like would help. Looking at what you posted I would expect you are asking to have a summary where for each unique site you have a count of records within each range you defined. Depending on the size of your actual data set this could be very large. Right now its 10x "columns" for the ranges and a row for x number of unique sites.

The SUMPRODUCT above will give you total count within a range, not by site (as far as I can tell). You could extend SUMPRODUCT to do this, but if I have understood what you asking for a COUNTIFS will do the trick as well.

Am I correct in my undertanding, that the results may be say another sheet (a summary sheet) with a layout like:

sites | range 0-5 | range 6-10 | range 11-30 | etc...
10010 | 2 | 4 | 6 | etc...
10021 | 6 | 13 | 2 | etc...
10026 | 7 | 1 | 0 | etc...
etc..

EDIT: Also, its very unusual to combine a VLOOKUP with formulas like COUNT/SUM/AVERAGE as VLOOKUP is a lookup type function that returns a single value from a place, whereas the other functional are mathematical and typically are most viable when given more than 1 numeric value. They both serve very different purposes depending on what you want to return. Generally if you are dealing with numeric values and need to analyze/summarize them (with or without conditions) then you want a variation of SUM/COUNT/AVERAGE/SUMPRODUCT etc. On the other hand if you need to return an existing value in a field given some criteria, then a lookup function like VLOOKUP or INDEX is what you would use.

Nice catch Zer0Cool, can't always tell from what is written what they really want, guess I missed the mark.

Not your fault, I've had problems at times with reading comprehension on this site.
Just glad someone got you what you wanted.

Ok, is your list of unique sites static or ever changing? IE: 10010, 10021, etc. are they always in this file (at least 1 time) or do new ones get added and/or old ones get removed? Also how many records are we talking about total, 100 rows, 1,000, 100,00?

Is this a 1 time thing or does this file get updated periodically and you will need to update the summary? If its updated, whats the process (is it a new file each time, if its the same file to you overwrite or append new entries, etc.)?

The answer above really determines how you get the unique list. If the list is pretty static in terms of unique sites, I just copy that column to another sheet and use remove duplicates on it to get my unique ID's, then create my headers and start on formulas. If that list is ever changing, I have to decide how much effort is needed and what approach is best for generating that unique list.

If its a new file every time I would likely create a macro and store it in my personal workbook or save it as an addin to use across the new files. If its the same file, data is appended and the unique ID's dont change, then I likely dont have to touch the summary sheet after its been setup, just use dynamic named ranges for the data or have the data placed in a table (the Excel feature, which expands with the data and uses structured references). If its the same file but the Unique ID's vary I might consider a Pivot Table or a combination of some macro code and formulas.

With a bit more info I could give you a more specific answer

Maybe this is what you want based on the replies so far?
I used sumproduct in various ranges and you can adjust them to continue.

See attached.

First thing to point out is your ranges overlap, so we have to make a choice about where the break points are. In my sample its as follows:

< 0, >= -5
< -5, >= -10
< -10, >= -30
< - 30, >=-50
< -50, >= -100

>= 0, < 5
>= 5, < 10
>= 10, < 30
>= 30, < 50
>= 50, <= 100

Also note your numbers are percentages, not whole numbers, thus 5 = .05, 10 = .1, 100 = 1, etc. You will see the conversion highlighted on the Ranges sheet/table

The COUNTIFS I used, will have put my foot in my mouth as I did actually combine it with VLOOKUP in this case since I am looking up the start/end of the desired ranges as thats not part of your actual data and its easier to get it from another table or key than it is to split apart the headers for those criteria values. Its basically 3 parts/criteria; the site, greater than and less than the bounds of the range for that column. As you can see from the subtotals and grand totals they match your data set.

I even added a filter to your data set so you can filter down to the site and range and compare the result to the formulas (this is how I verified my results).

SUMPRODUCT is one of my favorite functions as its extremely powerful and versatile. It should however be reserved for when another purpose built function cannot do the same job. A COUNTIF(S)/SUMIF(S)/AVERAGEIF(S) will always be more efficient (in terms of calc time and stress on the calc chain) as noted here (specifically under the "Optimize array formulas and SUMPRODUCT" and "Consider options for using SUM for multiple-condition array formulas" headings.)

Let me know if you have questions about the workbook.

Thank you Sambo kid for your suggestion. Much appreciated!

Unfortunately, because my dataset was quite large, I found Zer0Cool's suggestion worked much better.

But, thanks again for your time!

glad you got your solution AND thank you for the rep!

Glad it worked out for you and thanks for the rep as well.