Hi.
To some formulas like countif(); sumif(), we can type 1 condition to sort the
relevant data into use.
How about if I wish to use more than 1 condition?

Eg:
A------12
B------9
C------18
i-------30
ii-------45
iii------32

I would like to set the following conditions when using formulas like countif()
& sumif():
- select the right rows (eg containing A/B/C or i/ii/iii)
&
- select the right range of numbers (eg:
--- 10-20 [inclusive] for values in A/B/C;
--- 35-45[inclusive] for values in i/ii/iii)

How to do?


--
Additional information:
- I'm using Office XP
- I'm using Windows XP