How to SUM Data from non-regular rows
I am collecting data from source which omits categories with zero values. Therefore, number of rows will never be the same. Columns will always remain the same. I need to create an annual report based on monthly (or even daily) reports. The data will come like this (these are 3 separate reports combined already, one with XA-XD range, one without XB and one without XA, also some of them are with conditional value of Y or N): A B C D E Total XA Y 0 0 0 1 0 1 XB Y 0 1 0 0 0 1 XC Y 0 2 0 0 0 2 XD N 0 0 1 1 0 2 XA Y 0 1 0 2 0 3 XC Y 0 1 1 2 0 4 XD N 1 1 0 2 0 4 XB N 0 0 1 2 0 3 XC N 1 0 0 0 0 1 XD N 0 1 0 0 0 1 In the end I need report that contains summary for all rows with for each condition (IE XA with Y and XA with N) and then the same but for each condition in columns A to E. It all must be done with functions as I am working with around 50 columns and endless number of rows. I appreciate all help such as ready function as well as ideas (including VBA). Thanks
Weird type of row that I want gone but don't know what it's called.
So I got this template right, and one of the rows is special, it doesn't scroll when I scroll it just stays on the page, I can't delete it, and it's got a white arrow so I can filter stuff. It'd be perfect for a header kind of row. But I don't want it, I want to get rid of it, or at least the feature where it doesn't scroll down with me, but preferably just get rid of the type of row altogether.
Taking values from certain rows based on data input
So I'm trying to get a value into the column "Cat A Tied" (C column). This value depends on the number in the "# People Tied With" column (D Column). In this case, cell D2 has the number 3 in it. I want the sum of the first three rows of the B column (not including column headers) and then divide that by 3. However, I want the cell to be dynamic so if I change the number to 5 it will then automatically take the sum of the first 5 rows and divide by 5. Additionally, if I put this value into D3, the second row of my table, I'd want the first number (3 or 5, or any number put in) of rows from that same row onwards instead of from the first row of the data set. Any help would be greatly appreciated 🙂
