Try this: =SUMPRODUCT((A2:A6=1)*(B2:B6="del")*(C2:C6=FALSE)*(C2:C6<>"")) HTH Jason
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks