SUM PRODUCT Function

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

Hiya

Sorry about earlier message, sent it before completing it.

I have the following spreadsheet:

Partner Orpington FRICS
Partner Orpington FRICS

Partner Orpington BSc FRICS I Eng AMI Struct E
Partner Orpington FRICS

Partner Orpington BA(Hons) MRICS
Partner Orpington MRICS BSc
Partner Orpington BSc Dip Arch(Hons) RIBA

Partner Orpington ACIOB MAPM
Partner Orpington BSc MRICS

Partner/ Site Assessor Orpington BSc FRICS I Eng
AMI Struct E

Partner Associate Orpington BSc FRICS I Eng
AMI Struct E


Partner Orpington BSc MRICS



Partner Orpington MRICS
Partner Orpington BSc(Hons) Dip Arch Grad DiplCons
(AA) RIBA


Partner Orpington BSc MRICS


I am trying to work out a formula that will look for, say
all Partners, in Orpington who have the FRICS
qualification. However the in Partners column (Column B),
I need to search for Partner* (ie: Partner Associate or
Partnership Secretary). Also in column D I need to search
for all qualifications for FRICS but there may be text
before and after.

I have the following formula but it doesn't work: Any
help most welcome:

=SUMPRODUCT(--NOT(ISERR(SEARCH("partner",'Staff Schedule'!
B1:B996,(--NOT(ISERR(SEARCH("FRICS",'Staff Schedule'!
D1:D999,--('Staff Schedule'!C1:C996="Orpington")))))))))

Many thanks

Sue
 
Sue,

I don't know why it doesn't work for you. I added it and it works fine.

Did you create the formula, or did someone give it to you? The formula in
your post comes out at 3 lines, but when you add it needs to be strung
together.

What are you getting?
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top