Excel

[ajwags85]

=SUMIF(Sold[Date],"1/*",Sold[Total]) this should return a value of $4 and it return 0. why?

Case number: 1047519009

[#2]

@ajwags85 

It doesn't work because you're checking the cell for "1*" and the column contains dates represented by numbers. For example, 1/1/2023 is 44927.

Try this instead:

=SUM(IF(MONTH(Sold[Date])=1,Sold[Total]))

[#3]

That worked. Thank you!!!!

[#4]

You're welcome! Glad it worked.