Hi all,
I'm really struggling to crack a formula and hoping someone can advise.
I've downloaded my sales data over the last month - every transaction listed with date, time (to the second) and the value, and I am now trying to aggregate hourly sales to fit my staffing patterns.
I thought I had it with =SUMIFS(C:C,B:B,>11,B:B,<12) but it just gives me that annoying "there's something wrong, try =1+1=2, try an apostrophe if you don't want that!" type reply which is very useless...
In my sheet, column C is my transaction values, and B is the time. The plan being I'd go on to change "11" for D1, "12" for D2, and run through bar opening hours 11am to 10pm by hour, but I can't figure out what the problem with my formula is, or if its the best formula for the job. Any help would be really appreciated!
Thanks
I'm really struggling to crack a formula and hoping someone can advise.
I've downloaded my sales data over the last month - every transaction listed with date, time (to the second) and the value, and I am now trying to aggregate hourly sales to fit my staffing patterns.
I thought I had it with =SUMIFS(C:C,B:B,>11,B:B,<12) but it just gives me that annoying "there's something wrong, try =1+1=2, try an apostrophe if you don't want that!" type reply which is very useless...
In my sheet, column C is my transaction values, and B is the time. The plan being I'd go on to change "11" for D1, "12" for D2, and run through bar opening hours 11am to 10pm by hour, but I can't figure out what the problem with my formula is, or if its the best formula for the job. Any help would be really appreciated!
Thanks