COUNTIF using multiple criteria

[TritaniumZero]

Hi I need to write a formula which counts the number of cells where multiple
criteria are met.

For example, I need a countif statement (or equivelent) that will add up
total cells where F:F = "specific name" AND C:C begins with "FLT"

When I have tried it has run it as two seperate statements rather than like
a filtered search, so the result is wildly wrong.

Can anyone help please

Many Thanks in advance

 

[Toppers]

=SUMORODUCT(--(F2;F1000=X1),--(LEFT(C2:C1000),3)="FLT"))

X1 contains you name.

Unless you have XL2007, you cannot use whole columns as ranges.

 

[Bob Phillips]

SUMORODUCT? <vbg>

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Billy Liddel]

Try

=SUMPRODUCT(--(LEFT(C2:C500,3)="FLT"),--(F2:F500=F2))

Regards
Peter

 

[Toppers]

...... must get round to doing this typing course ......!

 

[Bob Phillips]

That will only get you making the mistakes quicker ... believe me, I know!

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)