Count text in one column Matching single or multiple Criteria from Other Column Excel 2003

Hi!
That's my first post, having read and tried many solutions... the formula COUNTIFS does not work (I guess) properly within Excel 2003 (still my version...)

Problem: Basically I need to count (counta) the text "x" in one column, IF a specific text "s" is found in the same row in another column.

1) GOAL 1: How many "x" we can find in column K when in the same row the column B has an "s"?

2) GOAL 2: How many "x" we can find in column K when in the same row the column B has an "s" AND the column D match an "f"?

I have attached a dummy example to illustrate my basic challenge.

Many thanks!

SUMPRODUCT is the way to go

=SUMPRODUCT(($D$4:$D$10="s")*($K$4:$K$10="x"))

=SUMPRODUCT(($D$4:$D$10="s")*($K$4:$K$10="x")*($F$4:$F$10="f"))

use sumproduct

=SUMPRODUCT((M4:M10="x")*(D4:D10="s"))
=SUMPRODUCT((M4:M10="x")*(D4:D10="s")*(F4:F10="f"))

change the cells to match your example - the above will work in the sample you attached - see below

is this a homework question ?

i have answered as I was not sure - but usually we would not do homework for you

you may want to lookup using sumproduct for count with multiple criteria
quite a few tutorials on the web

You are welcome and thanks for the feed back.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thank you.

See the forumulae I have put in D16 and D17 which answer your examples, and the explanation I have written next to them.

I hope that helps. Please ask if you have any further questions.