Having countif and sumif problems...

2 Things:

1) I want to sum Column Y if: Column B="coordinated" AND Column C="x"



2) I want to count Column T if: Column B="coordinated" AND Column C="x" AND Column D="potential letter"


Thoughts? THANKS!!!!

Try

1) =Sumproduct(--(B:B="coordinated"),--(C:C="x"),Y:Y)

and

2) =Sumproduct(--(B:B="coordinated"),--(C:C="x"),--(D:D="potential letter"),T:T)

although not quite sure what you mean by "Count column T"... do you mean sum.. or is there a T column Condition too....?