Following is my formula.
=SUMIF('This Year'!A1:A366,"<=C3",'This Year'!B1:B366)
I want the condition to use the VALUE of cell C3, not "C3", but I get an error when I try to remove the quotes.
What's the fix?
Thanks a bunch.
Following is my formula.
=SUMIF('This Year'!A1:A366,"<=C3",'This Year'!B1:B366)
I want the condition to use the VALUE of cell C3, not "C3", but I get an error when I try to remove the quotes.
What's the fix?
Thanks a bunch.
Cocantenation
"<="&C3
Thanks Very Much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks