Autofilter row selection

  • Thread starter Thread starter ianripping
  • Start date Start date
I

ianripping

Is there any way in which the number of a duplicated result in on
column can be linked to another coulmn. EG

_Column_A_ U]Column B[/U]

1 a
1 a
1 a
1 a
2 a
2 a
3 a
3 a
3 a

I want to find out how many a`s appear in Column B when Column A'
results are 1 only.

Any ideas? Using COUNTIF maybe
 
Ian,

=SUMPRODUCT((A1:A9=1)*(B1:B9="a"))

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
OK THIS IS GREAT. IM NEARLY THERE!

all i need now is for this to work but instead of a number and som
text, two pieces of text. So that I want the nmber of a's when ye
occur.

Can this be done
 
Bij replacing your 1 with yes and the other figures with no you get the same
result als the former formula if you use :

=SUMPRODUCT((A1:A9="yes")*(B1:B9="a"))

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top