Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hello Karen,I would like to help you with this formula.Please give me a minute to write it.
You are welcome!This is the formula:=SUMIFS($N$2:$N$58,$B$2:$B$58,">="&DATE(2013,2,1),$B$2:$B$58,"<="&DATE(2013,2,28))
Please note that the criteria and sume ranges must be the same size (your example had B2:B58 and N2:N62).
Thanks that's great
I am glad you like it!
yes all working thank you - have tried to rate you but won't let me so not sure if you need to do anything further your end?
Sorry for the trouble. Let me try to reload at my end.
Please try it now.
Karen, if rating is still disabled on your side, please try to leave the page using "Save & Exit" link and then come back.If that does not change it, let me know and I'll switch it to Q&A.I apologize for the trouble.
Sorry - it didn't work.
OK, thank you. I'll switch it to Q&A.