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