LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 31
Default Array Formula Help Needed

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Array formulas help needed ArthurN Excel Worksheet Functions 3 October 11th 07 10:03 PM
Maybe an array is needed? Arturo Excel Worksheet Functions 1 September 6th 06 01:26 PM
Array formula expertise needed CJ-22 Excel Worksheet Functions 0 February 10th 06 02:56 AM
Array formula needed ZipCurs Excel Worksheet Functions 4 December 17th 05 02:16 PM
Array formula needed Domenic Excel Worksheet Functions 0 August 26th 05 04:23 AM


All times are GMT +1. The time now is 07:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"