• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Text & Date Range

J

jei eusebio

Member
Hi Ninjas,

used this formula to get the sum for a certain criteria and date range .. comes up with the correct sum if I put a range on cell C2 & E2 (ex. 11/01/2015 - 11/28/2015) but only gives me zero when I put the same dates.

=SUMPRODUCT(--('CMS Raw'!$H:$H<=Dashboard!$E$2),--('CMS Raw'!$H:$H>=Dashboard!$C$2),--('CMS Raw'!$E:$E=$B$9&" "&Dashboard!$C10),'CMS Raw'!L:L)
Click to expand...

Thanks in advance! :)
 
Starting with the obvious, have you verified that your raw data has a record with date of exactly the value you're putting in C2 & E2? Note that if raw data has time stamps attached, that will mess things up.
 
Yup. Checked the raw data and everyting seems to be fine. It's already working now, for some reason .. I must have had a typo on the formula earlier since it worked after retyping. Anyways, Thanks for the response Luke. :)
 
It's also not good to refer entire columns in a sumproduct construct.

Can we have the xl with data pls.
 
You must log in or register to reply here.
Back
Top