New Contributor

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

Case number: 1047519009

3 Replies


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:

That worked. Thank you!!!!
You're welcome! Glad it worked.