Hi,
Thanks for great support beforehand!
I am trying to do sumifs with two criteria and the other one is causing problems. My criteria range cells are in 'date format as in '2.12.2017.
How to refer to this kind of cells?
This is working as I write the criteria date to the formula, but I need it to be formula too. How to do it?
Works:
=SUMIFS('OB YTD'!$AD:$AD;'OB YTD'!$G:$G;">'30.11.2017";'OB YTD'!$B:$B;$C$69)
Wont work:
=SUMIFS('OB YTD'!$AD:$AD;'OB YTD'!$G:$G;">"&"C68";'OB YTD'!$B:$B;$C$69)
=SUMIFS('OB YTD'!$AD:$AD;'OB YTD'!$G:$G;">'&"C68";'OB YTD'!$B:$B;$C$69)
=SUMIFS('OB YTD'!$AD:$AD;'OB YTD'!$G:$G;">"&"'"&"C68";'OB YTD'!$B:$B;$C$69)
=SUMIFS('OB YTD'!$AD:$AD;'OB YTD'!$G:$G;">(EOMONTH(TODAY();-1))";'OB YTD'!$B:$B;$C$69)
=SUMIFS('OB YTD'!$AD:$AD;'OB YTD'!$G:$G;">'(EOMONTH(TODAY();-1))";'OB YTD'!$B:$B;$C$69)
Thanks for any support!
-Erica
Thanks for great support beforehand!
I am trying to do sumifs with two criteria and the other one is causing problems. My criteria range cells are in 'date format as in '2.12.2017.
How to refer to this kind of cells?
This is working as I write the criteria date to the formula, but I need it to be formula too. How to do it?
Works:
=SUMIFS('OB YTD'!$AD:$AD;'OB YTD'!$G:$G;">'30.11.2017";'OB YTD'!$B:$B;$C$69)
Wont work:
=SUMIFS('OB YTD'!$AD:$AD;'OB YTD'!$G:$G;">"&"C68";'OB YTD'!$B:$B;$C$69)
=SUMIFS('OB YTD'!$AD:$AD;'OB YTD'!$G:$G;">'&"C68";'OB YTD'!$B:$B;$C$69)
=SUMIFS('OB YTD'!$AD:$AD;'OB YTD'!$G:$G;">"&"'"&"C68";'OB YTD'!$B:$B;$C$69)
=SUMIFS('OB YTD'!$AD:$AD;'OB YTD'!$G:$G;">(EOMONTH(TODAY();-1))";'OB YTD'!$B:$B;$C$69)
=SUMIFS('OB YTD'!$AD:$AD;'OB YTD'!$G:$G;">'(EOMONTH(TODAY();-1))";'OB YTD'!$B:$B;$C$69)
Thanks for any support!
-Erica