Hi All, I am new to this forum and hoping someone can help me as I am having trouble with SUMIF.
The issue I am having is that in the same column I am using the same formula, just changing the criteria to what I need. Though in certain instances it works as it should and in other instances, it returns 0 when I know it should return a result. Its a simple formula of =SUMIF($C$4:$L$100,"Beach",$G$4:$G$100) that returns a 0 but =SUMIF($C$4:$L$100,"Hoody Anorak",$G$4:$G$100) returns a result as it is meant to.
I have highlighted the instances in red in column Q as I am having the same issue with the Days.
I have attached a copy of the spreadsheet and would love to know what I am doing wrong???
(I have changed some of the data to be text or Date but doesn't seem to matter)
Bookmarks