non continuous

Hello All, I am struggling to find a way to COUNTIF the rows label 'Qty' are less than a value. I have tried naming the range but COUNTIF doesn't seem to work on a named range. Ultimately I would like formulas to for Qty < 30, Qty < 40, etc. I would do the same with time (formatted in m:ss)...

Hi I have a spreadsheet laid out with value, category, value, category, etc, across multiple columns on a spreadsheet. What I need to do is add together all the values in the columns (A,C,E,G, etc)based on the category in the column to the right of it (B,D,F, H, etc). So I'd end up with a...

I need help with creating a pattern with the average formula. I'm brand new to this site so I tried a search, but didn't have any luck finding what I wanted. This is the formula I'm currently using: =IFERROR(AVERAGE(B19,B32,B45,B58,B71),"") The IFERROR is for the cells that can't divide by 0...

I have a large set of part numbers that I need to summarize for the vehicle make and year ranges that they fit. I took the simple approach of finding the min and max year and concatenating make, max year - min year (e.g. Chev 2004-2000). However the year ranges are not always continuous and I...

Hello, here's the thing. I want to select a range of values but this ranges are not continuous. I tried =OFFSET(I21;;;;2)&OFFSET(I21;;5;;3) I would need this to select I21,I22,I26,I27,I28 I'm trying to define a Name Range with this, but as I test it, it won't be highlighted as a range. I...