Forum Discussion
Sumifs
Hi. I'm using SUMIFS to search totals between dates based on a certain type. How do make this same field give me all of the values between dates, regardless of type? In other words, I want the option of giving me all values from 9/1/18 - 9/5/18 or specific sales categories for this same type period. Thanks in advance.
Scott, you may use *, please see attached
6 Replies
I guess second, when if in A1 first date, in A2 - last one and in A3 desired sales category
=SUMIFS(<totals tange>, <dates range>, ">="&$A$1,<dates range>, "<="&$A$2, <category range>,$A$3)
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.
Scott, you may use *, please see attached
Hi Scott,
Please clarify, you need
dates range OR sales category; or
dates range AND sales category
