| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum of a column on condition
"Chris Bode via OfficeKB.com" wrote: A1:A10 contain date in C1:C10 add following formula =MONTH(A1) in D1:D10 add following formula =SUMIF(C1:C10,MONTH(TODAY()),B1:B10) Chris ------ Some more detail on my question: Columns A to L represent Jan to Dec months Based on the current month, Sum of the entries in the corresponding column are needed in another worksheet which is used every month to project the details of that month only The column hence needs to be determined by the current month |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting entries in column based on condition in another column | Excel Worksheet Functions | |||
| adding numbers from column B, while condition on column A | Excel Discussion (Misc queries) | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| how to count a column based on condition of another column | Excel Worksheet Functions | |||
| help me getting value of column based on condition | Excel Worksheet Functions | |||
Threaded Mode
