I am trying to use SUMIFS to total only lines that have two named values that are met.
Looking to only total from data if "SHOP1" and "*any date shown*" to give me a total for the sales dollars.
Something like =SUMIFS(Sheet4!AI:AI,Sheet4!C:C,"*shop1*",Sheet4!H:H," ")
Sales dollars are in column AI, shop name is in column C, and "*any date*" in H. Can't quite get this to work. What am I doing wrong?
Bookmarks