More than 1 cell reference/range in formula

Hi.
To some formulas like countif(); sumif(), we can type 1 cell reference or cell
range.
How about if I wish to use to type more than 1

eg: countif(A1:A5, C1:C5, E1, E3, E5...
However this method doesn't work.
How to do?


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

Hi,

How about something like this:

=SUMPRODUCT(COUNTIF(INDIRECT({"A2:A5","C1:C5","E1","E3","E5"}),">2"))

Regards,
KL



"0-0 Wai Wai ^-^" <[email protected]> wrote in message
news:[email protected]...
>
> Hi.
> To some formulas like countif(); sumif(), we can type 1 cell reference or
> cell
> range.
> How about if I wish to use to type more than 1
>
> eg: countif(A1:A5, C1:C5, E1, E3, E5...
> However this method doesn't work.
> How to do?
>
>
> --
> Additional information:
> - I'm using Office XP
> - I'm using Windows XP
>
>
>
>

Hi.
It seems the formula is quite complex.
I have to experiment with it first.

By the way, actually what topics/techniques should I read in order to learn how
to input:
- more than 1 cell reference in different formulas
- more than 1 criterion in different formulas
-- use AND, OR to link each criteria (eg criterion1 AND criterion2 OR
criterion3)

Currently, it seems different formulas have different ways to achieve the above.
(eg if I use countif, I need to do in XX way. If I use sunif, I need to do it in
YY way, and so on).
It would be great if I can learn the technique to do the above, so I don't need
to remember each by each rigidly.