Hi All,

I have 4 columns
a= Date
b = Locations (irrelevant for this formula)
c = type
d = qty

Im and trying to do a formula which will sum the qty column if date is a Monday to Saturday and the type column says WHB.

I have tried

=SUMIFS(D350:D370,A350:A370,WEEKDAY(A350:A370,2)<7,C350:C370,"WHB")

It just returns zero but i know there is data there that satisfies the conditions, im thinking it has something to do with my weekday function.

Any help would be appreciated.

Thanks