More than 1 cell reference/range in formula

  • Thread starter Thread starter 0-0 Wai Wai ^-^
  • Start date Start date
0

0-0 Wai Wai ^-^

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?
 
Hi,

How about something like this:

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

Regards,
KL
 
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.
 
Back
Top