subtotal columns

Hello, I am using this formula to count the text items selected in a column that contains a drop-down list in each cell with some cells containing multiple items selected in each drop down. I am using this format so it displays visible filtered results accurately. This formula works but...

Hi I have a report which pulls values from 2 sources (13 from each) for each month of the year, so 312 columns in total. For each line, I need to subtotal each source per month to compare these totals, and also get the annual totals for comparison. How can I get this? Thanks in advance.

Hello, I have a list of expenditures that gets longer as time goes on. I used the following code to select the last cell with data in column J, skip two rows down, and add a subtotals formula. Now I want to drag the formula to the right, but can’t seem to set it up right. The starting row...

This is off by five, but only when I'm looking for zero (0). There are no blank cells in the AV column, other than actually empty cells. The count is also off when I turn all filters off... Thoughts? =SUMPRODUCT(SUBTOTAL(2,OFFSET(A17,ROW(AV:AV)-ROW(A17),0)),--(AV:AV=0))

OK to me this should be simple, but I can't get Excel to do what I want :S Rows: Name Columns: Month, SalesType Value: Amount So what currently happens is that it splits the amounts by Month then by SalesType. What I'd like to do is have a final column at the end totalling it by SalesType...