How do I use the SUMIF formula using data from another sheet to add the results within a date range?

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

How do I use the SUMIF formula using data from another sheet to add the results within a date range?

My formula is below and is returning "INCORRECT ARGUMENT".

=SUMIF({Weekly Production Orders Range 2}, AND(ISBLANK(@cell) = false, AND(@cell >= DATE(2020, 1, 12), @cell <= DATE(2020, 1, 18))), [Week 1]2:[Week 1]10)

Answers

  • I figured out the problem.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Roshawnda,

    Glad to hear that you solved it!

    What was the issue? Good for others searching for a similar solution.

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • In the last argument I should have referenced the other sheet {Weekly Production Orders Range 4} to calculate the values from the Weekly Production Orders sheet, which contains most of the data.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Ok.

    Please help the Community by marking the post that helped answer your question or solve your problem with the accepted answer. It will make it easier for others to find a solution or help to answer!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.