Try this:
=SUMPRODUCT((ABS($C$2:$C$48)>2)*(ABS($C$2:$C$48)<4)*($G$2:$G$48="Y"))
Hope this helps.
Pete
Try this:
=SUMPRODUCT((ABS($C$2:$C$48)>2)*(ABS($C$2:$C$48)<4)*($G$2:$G$48="Y"))
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks