Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a spreadsheet listed by day as follows. I need the
data from column B, C & D summarized by month. How do I do that? Col A Col B Col C Col D 01/01/04 5 5 4 02/01/04 6 6 6 03/03/04 7 0 0 I need the result to look like this - Jan 04 11 11 10 Mar 04 7 0 0 How do I tell it to search for dates between 01/01/04 - 31/01/04 in column A then add column B, C or D to comue up with my totals for Jan 04? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
Formula Does Not Omit Criteria | Excel Worksheet Functions | |||
Formula to determine a future date based on criteria | Excel Worksheet Functions | |||
Need formula to check values of data in several cells as criteria | Excel Worksheet Functions |