• 100% Satisfaction Guarantee
AAATom, Consultant
Category: Microsoft
Satisfied Customers: 468
Experience:  Master's Degree in Computer Science, 20+ years of experience
66411959
AAATom is online now

# I need to find the correct date content for this formula -

### Resolved Question:

I need to find the correct date content for this formula - =sumif(\$B\$2:\$B\$58,>01/02/2013,N2:N62) I actually want to sum the values in column N if the date in column B falls within February i.e. between 1 Feb 13-28 Feb 13. Thanks
Submitted: 3 years ago.
Category: Microsoft
Expert:  AAATom replied 3 years ago.

AAATom :

Hello Karen,

Please give me a minute to write it.

AAATom :

Thank you,
Tom

Customer:

thanks

AAATom :

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))

AAATom :

Please note that the criteria and sume ranges must be the same size (your example had B2:B58 and N2:N62).

Customer:

Thanks that's great

AAATom :

I am glad you like it!

Customer:

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?

AAATom :

Sorry for the trouble. Let me try to reload at my end.

AAATom :

AAATom :

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.

Customer:

Sorry - it didn't work.

AAATom :

OK, thank you. I'll switch it to Q&A.