How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask AAATom Your Own Question
AAATom
AAATom, Consultant
Category: Microsoft
Satisfied Customers: 468
Experience:  Master's Degree in Computer Science, 20+ years of experience
66411959
Type Your Microsoft Question Here...
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,

I would like to help you with this formula.

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 :

Please try it now.

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.

AAATom and 3 other Microsoft Specialists are ready to help you
Expert:  AAATom replied 3 years ago.
Hello Karen,

please try to rate now.

Thank you,
Tom