I am trying to combine two functions countifs & frequency to no avail. The individual formulas are listed below. To explain the purpose here is a simple example. If there is a diner, I want to know how many people order breakfast in a month on odd days within a price range. I then want to know how many of those people are unique users and not repeat accounts. Any alternative solutions more than welcome. %Right now I am limited to finding all accounts or all counts of instances meeting the criterias.
=COUNTIFS(Sheet2!$E:$E,Sheet1!$B$1,Sheet2!$D:$D,Sheet1!$D$1,Sheet2!$G:$G,">="&Sheet1!$B24,Sheet2!$G:$G,"<"&$C24)
=SUM(IF(FREQUENCY(Sheet2!b:b,Sheet2!b:b!)>0,1))
Bookmarks