Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have the following data in a table (6 rows, 3 columns):
A .02 2/1/07 B .05 3/1/07 A .02 4/1/07 B .05 5/1/07 A .02 6/1/07 B .05 7/1/07 I want to find the sum of the 2nd column, but between certain dates. I want to find the sum of B between 3/1/07 - 5/1/07. The answer would equal .10 The only way I know how to do this is through a sumif formula, which will give me .15 as an answer to my previous question. I am unsure how to add the date range into my search criteria. Any and all help is greatly appreciated! Regards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i search for a specific name in an excel file | Excel Discussion (Misc queries) | |||
How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
Search for record with specific name in a cell | Excel Worksheet Functions | |||
Search for specific words | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions |