Excel

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

@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]))
That worked. Thank you!!!!
You're welcome! Glad it worked.