Hi All -
I'm having an issue with an array formula. Basically what I have set up is the following formula =SUM(IF(($B$2:$B$243>=E15)*($B$2:$B$243<=F15),$C$2:$C$243)).
This formula will look at the specific criteria and determine how many clicks are within the "start" and "end" range criteria that I have predetermined. The total number of clicks is just over 20K but after running the array I am getting 26,558 clicks which doesn't make any sense.
Could someone take a look at the attached spreadsheet and let me know what I am doing incorrectly?