Prev: updating cell range depending on input value
Next: Hyperlink won't open in excel
From: nelly on 13 Apr 2010 07:43
Thanks for the replies - Many THanks they are all spot on.

Think I was missing the obvious....

"nelly" wrote:

> 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
First  |  Prev  | 
Pages: 1 2
Prev: updating cell range depending on input value
Next: Hyperlink won't open in excel