LinkBack URL
About LinkBacks
Then change the operators:
=SUM(SUMIFS(S:S,N:N,A1,M:M,"pleted ",P:P,{"<=200",""},R:R,{">=6";"<8"}))
Why not just say =7, though?
Or maybe you want this?
=SUM(SUMIFS(S:S,N:N,A1,M:M,"pleted ",P:P,{"<=200",""},R:R,">=6",R:R,"<8"))
Then change the operators:
=SUM(SUMIFS(S:S,N:N,A1,M:M,"pleted ",P:P,{"<=200",""},R:R,{">=6";"<8"}))
Why not just say =7, though?
Or maybe you want this?
=SUM(SUMIFS(S:S,N:N,A1,M:M,"pleted ",P:P,{"<=200",""},R:R,">=6",R:R,"<8"))
Last edited by AliGW; 06-02-2018 at 04:13 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks