S snake12 New Member Dec 22, 2011 #1 I have the following formula that I can't get to work in Excel 2003. Would greatly appreciate it if someone can help. =SUMIFS(Sheet1!$M$3:$M$18,Sheet1!$B$3:$B$18,Sheet2!A63,Sheet1!$O$3:$O$18,"<="&$B$58)
I have the following formula that I can't get to work in Excel 2003. Would greatly appreciate it if someone can help. =SUMIFS(Sheet1!$M$3:$M$18,Sheet1!$B$3:$B$18,Sheet2!A63,Sheet1!$O$3:$O$18,"<="&$B$58)
Hui Excel Ninja Staff member Dec 22, 2011 #2 Snake12 Firstly, Welcome to the Chandoo.org Forums Give the following a try: Code: =SUMPRODUCT((Sheet1!$B$3:$B$18=Sheet2!A63)*(Sheet1!$O$3:$O$18<=$B$58),Sheet1!$M$3:$M$18)
Snake12 Firstly, Welcome to the Chandoo.org Forums Give the following a try: Code: =SUMPRODUCT((Sheet1!$B$3:$B$18=Sheet2!A63)*(Sheet1!$O$3:$O$18<=$B$58),Sheet1!$M$3:$M$18)
S snake12 New Member Dec 22, 2011 #3 Hui Wow, excel ninja indeed. That worked beautifully, now I have to figure it out backwards. Thank you very much!
Hui Wow, excel ninja indeed. That worked beautifully, now I have to figure it out backwards. Thank you very much!
