Hi all,
In my spreadsheet I have two columns. The possible values within Column A are size (SMall, Medium LArge). The possible values in Column B are Season/Year references (Spring 2011, Summer 2011, Fall 2011, Winter 2011, Summer 2012...)
What I am trying to do is create a sumproduct formula that says, count number of Small items that are in place within the YEAR of 2011. C1 is cell reference for Small and D1 is a cell which currently contains Spring 2011.
I have tried
=sumproduct(--(A1:A100="C1"),--(B1:B100=right(D1,4)))
I have also tried replacing the back half of the equation with (isnumber(find(right(D1,4)...
but that hasn't worked either. Any help would be much appreciated.
Thanks
In my spreadsheet I have two columns. The possible values within Column A are size (SMall, Medium LArge). The possible values in Column B are Season/Year references (Spring 2011, Summer 2011, Fall 2011, Winter 2011, Summer 2012...)
What I am trying to do is create a sumproduct formula that says, count number of Small items that are in place within the YEAR of 2011. C1 is cell reference for Small and D1 is a cell which currently contains Spring 2011.
I have tried
=sumproduct(--(A1:A100="C1"),--(B1:B100=right(D1,4)))
I have also tried replacing the back half of the equation with (isnumber(find(right(D1,4)...
but that hasn't worked either. Any help would be much appreciated.
Thanks