I have the following formula and would like to sumif only if less than date that is in cell r2. I tried entering: ,"<"&r2 but that didn't work.
=SUMIFS(Sheet4!V:V,Sheet4!A:A,C3,Sheet4!N:N,Sheet1!$S$2)
I have the following formula and would like to sumif only if less than date that is in cell r2. I tried entering: ,"<"&r2 but that didn't work.
=SUMIFS(Sheet4!V:V,Sheet4!A:A,C3,Sheet4!N:N,Sheet1!$S$2)
"<"&R2 is the correct syntax to do a less than cell criteria.
Which column contains the date you're comparing with?
Are you sure they are real dates? Verify with ISNUMBER
=ISNUMBER(R2)
Repeat for the cells you want to compare to R2.
Are they True or False?
sometimes I find it easier to convert the date to a number and use the number in the formula instead. For example 1/16/2018 is 43116 as a number.
but it should work if it is a date, per Jonmo1's post.
Last edited by Sam Capricci; 01-16-2018 at 02:31 PM.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
ok, my issue was that I didn't have the column with my dates. i entered that in then the sytax and it worked. thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks