Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi...I've read several post based on what I'm looking for, but I haven't been
able to complete what I'm trying to do. I'm attempting to find the average on a column $I3:$I65536. This average is only if it equals items in range $F3:$F65536 and within a date range that I would like to be able to change from time to time...the date range is $B3:$B65536. I've been able to do it when there is exact match of two items, but have not seen a way to do it with the date range. The next formula should be easier...I'd like to SUMIF $K3:$K65536 based on the same parameters listed on the above average formula. Any thoughts would be greatly appreciated. Cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating values in two columns based on a variable | Excel Discussion (Misc queries) | |||
get a total based on criteria in two columns | Excel Worksheet Functions | |||
how do I lookup data based on two columns of data | Excel Worksheet Functions | |||
How do I automatically hide columns in a worksheet based on a cell value? | Excel Worksheet Functions | |||
Hiding columns based on user/password | Excel Worksheet Functions |