Within my workbook, the first tab is an import range of data for sales that includes: date of sale (found in column A), agent name (found in column B), price (column C)
When using the following equation with the import data on a separate tab, the result yields 0. =SUMIFS($C$2:$C,$B$2:$B,"="&I6,$A$2:$A,">="&$K$2,$A$2:$A,"<="&$K$3)
How can I fit the above equation into a Query Function? I would like to have the import range on the first tab with the subsequent tabs displaying the sum total of agent sales based off their name and date range.
I6= agent name
K2= start date range
K3=end date range
Bookmarks