Excel Query

[jellybeard999]

What is the best way to achieve the following;

  A   B    C
1 X High   1
2 X Low    2
3 Y High   3
4 X Medium 1

I'm looking to get a count, so that, for example,

If column A contains X, how many of those are High (ie return a value of 1)
If column A contains Y, how many of those are below 2 (ie return a value of 0)

Any ideas? Hopefully this isn't too vague.

If possible, I'd like it to just pick up data from a sheet dropped in, without altering the data, for example have a sheet called "summary" and another with "data". Anything copied and pasted into data is automatically calculated in summary.

Thanks for any ideas.