Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Maxif
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 |
#2
|
|||
|
|||
one way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):
=MAX(IF(C2:C403,C2:C40),IF(D2:D4025,D2:D40)) In article , "Tom Hollies via OfficeKB.com" wrote: 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. |
#3
|
|||
|
|||
Do you mean the number has to be in both columns, or that whichever column
it is found in it adheres to the rules for that column alone. What do you want returned if there is no value that meets the criteria. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "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 |
#4
|
|||
|
|||
Are you sure about the criteria you state and the range for which a
conditional max must be calculated? As is, they sound unusual... Tom Hollies via OfficeKB.com wrote: 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 |
#5
|
|||
|
|||
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 |
#7
|
|||
|
|||
Thamks a lot, it worked a treat. I can't say I fully understand why but
that's not unusual for me, thanks again. Tom -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |