Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Three way array function
Are these possible? I've got the following formula to work out how many instances there are of "Apples" and "COM" occuring at the same time {=COUNT(IF((leasetracker!$E$2:$E$2000="Apples")*(l easetracker!$H$2:$H$2000="COM"),leasetracker!$A$2: $A$20000))} I want to work out how many times they occur between two dates. (They would be in column Z Many Thanks -- M3Cobb ------------------------------------------------------------------------ M3Cobb's Profile: http://www.excelforum.com/member.php...o&userid=24986 View this thread: http://www.excelforum.com/showthread...hreadid=545888 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OR function in array-entered IF function | Excel Worksheet Functions | |||
Help for Array function | Excel Worksheet Functions | |||
Is there an array function or something like it? | Excel Worksheet Functions | |||
Array Function help | Excel Programming | |||
UDF Array function | Excel Programming |