Average/Sumif based on several columns
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
|