forget this one
I might have thought of sth. better than that
;-)

On 21 Kwi, 15:40, Jarek Kujawa wrote:
this array-entered formula

=SUM(IF((COUNTIF($A$2:$A$9,$A$2:$A$9)=1)*($B$22:$B $29="yes"),1,))+SUM
(IF(($B$2:$B$9="yes")*(COUNTIF($A$2:$A$9,$A$23:$A$ 29)1),1,))/SUM(IF
(($B$2:$B$9="yes")*(COUNTIF($A$2:$A$9,$A$2:$A$29) 1),1,))

will bring required result unless you have blanks in your range

On 21 Kwi, 15:05, "Gareth.Evans" wrote:



On Apr 21, 1:47Â*pm, Jarek Kujawa wrote:

shouldn't the formula in your example return 1? as there are two 10's

if so try:

=SUMPRODUCT((COUNTIF($A$22:$A$29,$A$22:$A$29)=1)*( $B$22:$B$29="yes"))

OR
=SUM(IF((COUNTIF($A$2:$A$9,$A$2:$A$9)=1)*($B$2:$B$ 9="yes"),1,))
(CTRL+SHIFT+ENTER this formula as it is an array-formula (instead of
simply entering it). If you insert it correctly curly braces { } will
show)

pls click YES if this post helped you

On 21 Kwi, 14:34, "Gareth.Evans" wrote:

Hi all, thank you in advance for your help ,and help in past.

I am trying to count the number of "yes" in column C if Column A has a
unique value, see below:

Â*| Â* Â* Â* Â* A Â* Â* Â* Â* Â* | Â* Â* Â* Â* Â* B Â* Â* Â* Â* | Â* Â* Â* Â* C Â* Â* Â* Â*|
Â* Â* Â* Â* Â* 10 Â* Â* Â* Â* Â* Â* Â* Â* Â* Â*N/A Â* Â* Â* Â* Â* Â* Â* Â* yes
Â* Â* Â* Â* Â* 10 Â* Â* Â* Â* Â* Â* Â* Â* Â* Â*N/A Â* Â* Â* Â* Â* Â* Â* Â* yes
Â* Â* Â* Â* Â* 11 Â* Â* Â* Â* Â* Â* Â* Â* Â* Â*N/A Â* Â* Â* Â* Â* Â* Â* Â* no
Â* Â* Â* Â* Â* 11 Â* Â* Â* Â* Â* Â* Â* Â* Â* Â*N/A Â* Â* Â* Â* Â* Â* Â* Â* no
Â* Â* Â* Â* Â* 12 Â* Â* Â* Â* Â* Â* Â* Â* Â* Â*N/A Â* Â* Â* Â* Â* Â* Â* Â* yes
Â* Â* Â* Â* Â* 13 Â* Â* Â* Â* Â* Â* Â* Â* Â* Â*N/A Â* Â* Â* Â* Â* Â* Â* Â* no
Â* Â* Â* Â* Â* 13 Â* Â* Â* Â* Â* Â* Â* Â* Â* Â*N/A Â* Â* Â* Â* Â* Â* Â* Â* no
Â* Â* Â* Â* Â* 13 Â* Â* Â* Â* Â* Â* Â* Â* Â* Â*N/A Â* Â* Â* Â* Â* Â* Â* Â* no

Basically this is part of verifying invoices, A being the invoice
number, each invoice can have mnore then 1 entry thus there being two
10's.

Column C represtent weather that invoice entry has been a success or
not.

What i need to know is the number of invoices that were a success
(Column c)

So.... in the example above the formula would return 2, as invoice 10
and 12 were a success but not he others.

I hope i have made sense, i have been trying to figure this out for a
few days noe, i have got as far as working out the number of unique
entriers in column a by useing array formulas, but get stuck.

Hope someone can help

Many Thanks- Hide quoted text -

- Show quoted text -

No, it would return 2 because both invoice 10 and invoice 12 passed.- Ukryj cytowany tekst -

- Poka¿ cytowany tekst -- Ukryj cytowany tekst -

- Pokaż cytowany tekst -