range usage question
jz --
Here's something that works, but you can't use if for an entire column:
=sumproduct(A1:A100,--(B1:B100="word"))
HTH
"jzingman" wrote:
I want the maximum of column A when column B contains a certain word. I tried
=max(A:A*(B:B="word"))
but get 0. Thinking that the B reference was the problem, I tried
=max(B:B="word")
and get 0, although if I choose a cell that contains word,
=max(B5="word")
I get 1. So clearly I don't know how to do this reference. What's the
right way?
Thanks
|