Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Dear experts,
I've a table which column B to column M are months of 2008, e.g. B1 = Jan 08, C1 = Feb 08 and so forth. Then, in row 10, 15, 22, 35, 42........up to 372 are rows for totals of different departments (the number of rows for each department are not even). My question is, if I want to sum up all departments' totals of any month (say only April), are there any best and quickest ways (formula) to do it. If yes, please kindly advise. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
How do I view the maximum rows in Excel 2007 (Million Rows)? | Excel Discussion (Misc queries) | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions |