Thread
:
Excel Question
View Single Post
#
4
09-20-2005, 07:45 PM
Keats13
Member
Join Date: Mar 2004
Location: MA
Posts: 33
Re: Excel Question
Try (for A, for example)
=sum((i$1:i$6=m2)*(k$1:k$6="No")*j$1:j$6)
Then hit CTRL+SHIFT+ENTER (not just enter)
(The $ are not necessary, but enable you to copy & paste with ease.)
Keats13
View Public Profile
Find all posts by Keats13