Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi Guys
I need an array formula which counts the number of instances range Comp1 has a value greater then zero AND Range Comp2 has a blank value. Sounds simple but I just can't figure it out. Also would be helpfull would the same criterior but instead of counting the instances sums the vales in range Comp1 A B 1 1 3 1 2 1 1 1 4 4 Answer for formula 1 would be 2 and for formula 2 would be 4 Regards Nelly |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Array formulas help needed | Excel Worksheet Functions | |||
Maybe an array is needed? | Excel Worksheet Functions | |||
Array formula expertise needed | Excel Worksheet Functions | |||
Array formula needed | Excel Worksheet Functions | |||
Array formula needed | Excel Worksheet Functions |