Thread
:
Excel Maxif
View Single Post
#
5
Don Guillett
Posts: n/a
try this as an array formula which means you must enter with
ctrl+shift+enter
=MAX(MAX(IF(A2:A223,A2:A22)),MAX(IF(B2:B2225,B2: B22)))
--
Don Guillett
SalesAid Software
"Tom Hollies via OfficeKB.com" wrote in message
...
Hi,
Hi,
I wonder if anyone can help, I have 2 columns say C2:C40 and D2:D40 and I
need to add a function to say D50 that will return the Max for both
columns
provided the number is 3 in column C and 25 in column D.
Any Ideas regards Tom
--
Message posted via
http://www.officekb.com
Reply With Quote