Hey guys,
I'm having a problem with a formula I'm using to sum the values within a certain date range. They have to meet certain criteria also, but I have that part of the formula worked out already. Here is the formula I am using, with the part I believe is the problem in red:
=SUMPRODUCT(--([Register.xls]DATA!$B$2:$B$10000>=DATE(2009,11,1)),--([Register.xls]DATA!$B$2:$B$10000<=DATE
(2009,11,30)),--([Register.xls]DATA!$C$2:$C$10000=XTD!$E$100),--([Register.xls]DATA!$F$2:$F$10000=XTD!$A$106),
--([Register.xls]DATA!$G$2:$G$10000=XTD!$B$107),--([Register.xls]DATA!$H$2:$H$10000=XTD!$C$108),Register.xls]DA
TA!$J$2:$J$10000)
I searched around and tried replacing the ",--" with asterisks, I tried holding CTRL+SHIFT and pressing ENTER to activate it, and I just can't figure it out. Anybody understand what might be going wrong?
BTW big thanks to you guys for even helping me get to a point where I can attempt to write a formula like this!
Bookmarks