Formula Error

Question

HI,going to pull data from my mastersheet and bring it to the consolidated sheet and for this I've tried to use this formula, i'm keep getting this unpharseable error i didn't know what i did wrong, please help.

FORMULA - =SUMIFS({Order Value Sridhar Mastersheet}, {Sridhar Mastersheet Range 2,},"che",{Sridhar Mastersheet Range 3},"Production in process",{Sridhar Mastersheet Range 4}"<=01/10/2023",{Sridhar Mastersheet Range 4},"<=30/10/2023"))

Kelly Moore · Accepted Answer

Hey @vstr88889

Try this

=SUMIFS({Order Value Sridhar Mastersheet}, {Sridhar Mastersheet Range 2},"che", {Sridhar Mastersheet Range 3}, "Production in process", {Sridhar Mastersheet Range 4}, <=01/10/2023, {Sridhar Mastersheet Range 4},<=30/10/2023)

Will this work for you?

Kelly