I would like to count the # of times a value occurs in Col B base

I have 2 colums - satisfaction rating (Col A), and importance rating (Col B)

I would like to count the # of times a value occurs in Col B based on its
related value in Col A

That is, for example, count the number of occurences of a high importance,
but low satisfaction.

Can anyone help?

Same formula as in your previous question, but let's not hard code the
variables.
Designate particular cells to contain the criteria, so that you can easily
change them without having to revise the formula itself.

Previous formula:

=SUMPRODUCT((A1:A100="High")*(B1:B100="High"))

So, let's say you use C1 for the Column A criteria, and C2 for the Column B
criteria:

=SUMPRODUCT((A1:A100=C1)*(B1:B100=C2))

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"shopaholic" <[email protected]> wrote in message
news:[email protected]...
> I have 2 colums - satisfaction rating (Col A), and importance rating (Col
B)
>
> I would like to count the # of times a value occurs in Col B based on its
> related value in Col A
>
> That is, for example, count the number of occurences of a high importance,
> but low satisfaction.
>
> Can anyone help?

Thanks so much. Thats perfect!

"RagDyer" wrote:

> Same formula as in your previous question, but let's not hard code the
> variables.
> Designate particular cells to contain the criteria, so that you can easily
> change them without having to revise the formula itself.
>
> Previous formula:
>
> =SUMPRODUCT((A1:A100="High")*(B1:B100="High"))
>
> So, let's say you use C1 for the Column A criteria, and C2 for the Column B
> criteria:
>
> =SUMPRODUCT((A1:A100=C1)*(B1:B100=C2))
>
> --
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
>
> "shopaholic" <[email protected]> wrote in message
> news:[email protected]...
> > I have 2 colums - satisfaction rating (Col A), and importance rating (Col
> B)
> >
> > I would like to count the # of times a value occurs in Col B based on its
> > related value in Col A
> >
> > That is, for example, count the number of occurences of a high importance,
> > but low satisfaction.
> >
> > Can anyone help?
>
>

You're welcome.
Thanks for the feed-back.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"shopaholic" <[email protected]> wrote in message
news:[email protected]...
Thanks so much. Thats perfect!

"RagDyer" wrote:

> Same formula as in your previous question, but let's not hard code the
> variables.
> Designate particular cells to contain the criteria, so that you can easily
> change them without having to revise the formula itself.
>
> Previous formula:
>
> =SUMPRODUCT((A1:A100="High")*(B1:B100="High"))
>
> So, let's say you use C1 for the Column A criteria, and C2 for the Column
B
> criteria:
>
> =SUMPRODUCT((A1:A100=C1)*(B1:B100=C2))
>
> --
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
>
> "shopaholic" <[email protected]> wrote in message
> news:[email protected]...
> > I have 2 colums - satisfaction rating (Col A), and importance rating
(Col
> B)
> >
> > I would like to count the # of times a value occurs in Col B based on
its
> > related value in Col A
> >
> > That is, for example, count the number of occurences of a high
importance,
> > but low satisfaction.
> >
> > Can anyone help?
>
>