| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help - Search for set dates then average other cells values
Hi,
I hope someone can help me. I have a spreadsheet that has Dates in Column A - Eg 01/01/06 to 31/12/06. Each date has a value next to it in Column B Can you search for between specific dates and then average the values in column B that link to the dates in the range? Many thanks in advance Rob |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help - Search for set dates then average other cells values
This worked using US dates (1/1/06 & 12/31/06) so it should work with your
date format, I think. =(SUMIF(A1:A100,"=1/1/06",B1:B100)-SUMIF _(A1:A100,"=31/12/06",A1:A100))/ _ (COUNTIF(A1:A100,"=A/1/06")- _ (COUNTIF(A1:A100,"31/12/06"))) -- Best wishes, Jim "rob117" wrote: Hi, I hope someone can help me. I have a spreadsheet that has Dates in Column A - Eg 01/01/06 to 31/12/06. Each date has a value next to it in Column B Can you search for between specific dates and then average the values in column B that link to the dates in the range? Many thanks in advance Rob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| average of different cells ignoring zero values | Excel Discussion (Misc queries) | |||
| from a group of cells.find average of cells containing values | Excel Discussion (Misc queries) | |||
| average values in non-contiguous cells, ignoring 0 values | Excel Worksheet Functions | |||
| How do I obtain the Average Values between 2 dates? | Excel Worksheet Functions | |||
| Running average without nonzero values or empty cells | Excel Programming | |||
Linear Mode
