I have this formula which works fine but I want to add another criteria....
look for text C in cells M1:M1976 (these cells contain C 1, C 2, S 1, S 2, S3...)
I want to sum only those with "C"
=SUMIFS(Data!$Q$1:$Q$1976,Data!$B$1:$B$1976,"E",Data!$I$1:$I$1976,">=01/01/2018",Data!$I$1:$I$1976,"<=31/1/2018")
Thank you
Bookmarks