Sumifs

Thanks for contacting me Sergie.

I have dates in a column; I have sales in a column; and I have sales channel (or type) in a column.

The formula is asking to search the sales column for a date greater than/equal to.... and less than/equal to...., then scanning the channel column for that particular channel.

I have the dates in the formula referencing cells where I can change the entries.  I have the channel referencing a cell where I can change the entry.  When I enter the dates, to and from, and the channel I get a result.  This works great.  I'm looking for a way to make an entry in the channel field whereby it brings me all of the cells in that date range, regardless of channel.

I hope I haven't confused this.