Count the occurence of more than one condition

Got this function from Excel Help but it gives me #Value error. Can anyone help?





=SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))

Number of invoices for Buchanan with a value less than 9,000. (1)

It is an array formula, so after typing it, hit Ctrl-Shift-Enter together,
not just Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wutang1105" <[email protected]> wrote
in message news:[email protected]...
>
> Got this function from Excel Help but it gives me #Value error. Can
> anyone help?
>
>
>
>
>
> =SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))
>
> Number of invoices for Buchanan with a value less than 9,000. (1)
>
>
> --
> wutang1105
> ------------------------------------------------------------------------
> wutang1105's Profile:
http://www.excelforum.com/member.php...o&userid=26683
> View this thread: http://www.excelforum.com/showthread...hreadid=399547
>

It is an array formula, so after typing it, hit Ctrl-Shift-Enter together,
not just Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wutang1105" <[email protected]> wrote
in message news:[email protected]...
>
> Got this function from Excel Help but it gives me #Value error. Can
> anyone help?
>
>
>
>
>
> =SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))
>
> Number of invoices for Buchanan with a value less than 9,000. (1)
>
>
> --
> wutang1105
> ------------------------------------------------------------------------
> wutang1105's Profile:
http://www.excelforum.com/member.php...o&userid=26683
> View this thread: http://www.excelforum.com/showthread...hreadid=399547
>

It is an array formula, so after typing it, hit Ctrl-Shift-Enter together,
not just Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wutang1105" <[email protected]> wrote
in message news:[email protected]...
>
> Got this function from Excel Help but it gives me #Value error. Can
> anyone help?
>
>
>
>
>
> =SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))
>
> Number of invoices for Buchanan with a value less than 9,000. (1)
>
>
> --
> wutang1105
> ------------------------------------------------------------------------
> wutang1105's Profile:
http://www.excelforum.com/member.php...o&userid=26683
> View this thread: http://www.excelforum.com/showthread...hreadid=399547
>

It is an array formula, so after typing it, hit Ctrl-Shift-Enter together,
not just Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wutang1105" <[email protected]> wrote
in message news:[email protected]...
>
> Got this function from Excel Help but it gives me #Value error. Can
> anyone help?
>
>
>
>
>
> =SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))
>
> Number of invoices for Buchanan with a value less than 9,000. (1)
>
>
> --
> wutang1105
> ------------------------------------------------------------------------
> wutang1105's Profile:
http://www.excelforum.com/member.php...o&userid=26683
> View this thread: http://www.excelforum.com/showthread...hreadid=399547
>

It is an array formula, so after typing it, hit Ctrl-Shift-Enter together,
not just Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wutang1105" <[email protected]> wrote
in message news:[email protected]...
>
> Got this function from Excel Help but it gives me #Value error. Can
> anyone help?
>
>
>
>
>
> =SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))
>
> Number of invoices for Buchanan with a value less than 9,000. (1)
>
>
> --
> wutang1105
> ------------------------------------------------------------------------
> wutang1105's Profile:
http://www.excelforum.com/member.php...o&userid=26683
> View this thread: http://www.excelforum.com/showthread...hreadid=399547
>

It is an array formula, so after typing it, hit Ctrl-Shift-Enter together,
not just Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wutang1105" <[email protected]> wrote
in message news:[email protected]...
>
> Got this function from Excel Help but it gives me #Value error. Can
> anyone help?
>
>
>
>
>
> =SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))
>
> Number of invoices for Buchanan with a value less than 9,000. (1)
>
>
> --
> wutang1105
> ------------------------------------------------------------------------
> wutang1105's Profile:
http://www.excelforum.com/member.php...o&userid=26683
> View this thread: http://www.excelforum.com/showthread...hreadid=399547
>

It is an array formula, so after typing it, hit Ctrl-Shift-Enter together,
not just Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wutang1105" <[email protected]> wrote
in message news:[email protected]...
>
> Got this function from Excel Help but it gives me #Value error. Can
> anyone help?
>
>
>
>
>
> =SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))
>
> Number of invoices for Buchanan with a value less than 9,000. (1)
>
>
> --
> wutang1105
> ------------------------------------------------------------------------
> wutang1105's Profile:
http://www.excelforum.com/member.php...o&userid=26683
> View this thread: http://www.excelforum.com/showthread...hreadid=399547
>

It is an array formula, so after typing it, hit Ctrl-Shift-Enter together,
not just Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wutang1105" <[email protected]> wrote
in message news:[email protected]...
>
> Got this function from Excel Help but it gives me #Value error. Can
> anyone help?
>
>
>
>
>
> =SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))
>
> Number of invoices for Buchanan with a value less than 9,000. (1)
>
>
> --
> wutang1105
> ------------------------------------------------------------------------
> wutang1105's Profile:
http://www.excelforum.com/member.php...o&userid=26683
> View this thread: http://www.excelforum.com/showthread...hreadid=399547
>

It is an array formula, so after typing it, hit Ctrl-Shift-Enter together,
not just Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wutang1105" <[email protected]> wrote
in message news:[email protected]...
>
> Got this function from Excel Help but it gives me #Value error. Can
> anyone help?
>
>
>
>
>
> =SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))
>
> Number of invoices for Buchanan with a value less than 9,000. (1)
>
>
> --
> wutang1105
> ------------------------------------------------------------------------
> wutang1105's Profile:
http://www.excelforum.com/member.php...o&userid=26683
> View this thread: http://www.excelforum.com/showthread...hreadid=399547
>

It is an array formula, so after typing it, hit Ctrl-Shift-Enter together,
not just Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wutang1105" <[email protected]> wrote
in message news:[email protected]...
>
> Got this function from Excel Help but it gives me #Value error. Can
> anyone help?
>
>
>
>
>
> =SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))
>
> Number of invoices for Buchanan with a value less than 9,000. (1)
>
>
> --
> wutang1105
> ------------------------------------------------------------------------
> wutang1105's Profile:
http://www.excelforum.com/member.php...o&userid=26683
> View this thread: http://www.excelforum.com/showthread...hreadid=399547
>

It is an array formula, so after typing it, hit Ctrl-Shift-Enter together,
not just Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wutang1105" <[email protected]> wrote
in message news:[email protected]...
>
> Got this function from Excel Help but it gives me #Value error. Can
> anyone help?
>
>
>
>
>
> =SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))
>
> Number of invoices for Buchanan with a value less than 9,000. (1)
>
>
> --
> wutang1105
> ------------------------------------------------------------------------
> wutang1105's Profile:
http://www.excelforum.com/member.php...o&userid=26683
> View this thread: http://www.excelforum.com/showthread...hreadid=399547
>

It is an array formula, so after typing it, hit Ctrl-Shift-Enter together,
not just Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wutang1105" <[email protected]> wrote
in message news:[email protected]...
>
> Got this function from Excel Help but it gives me #Value error. Can
> anyone help?
>
>
>
>
>
> =SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))
>
> Number of invoices for Buchanan with a value less than 9,000. (1)
>
>
> --
> wutang1105
> ------------------------------------------------------------------------
> wutang1105's Profile:
http://www.excelforum.com/member.php...o&userid=26683
> View this thread: http://www.excelforum.com/showthread...hreadid=399547
>

It is an array formula, so after typing it, hit Ctrl-Shift-Enter together,
not just Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wutang1105" <[email protected]> wrote
in message news:[email protected]...
>
> Got this function from Excel Help but it gives me #Value error. Can
> anyone help?
>
>
>
>
>
> =SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))
>
> Number of invoices for Buchanan with a value less than 9,000. (1)
>
>
> --
> wutang1105
> ------------------------------------------------------------------------
> wutang1105's Profile:
http://www.excelforum.com/member.php...o&userid=26683
> View this thread: http://www.excelforum.com/showthread...hreadid=399547
>

It is an array formula, so after typing it, hit Ctrl-Shift-Enter together,
not just Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wutang1105" <[email protected]> wrote
in message news:[email protected]...
>
> Got this function from Excel Help but it gives me #Value error. Can
> anyone help?
>
>
>
>
>
> =SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))
>
> Number of invoices for Buchanan with a value less than 9,000. (1)
>
>
> --
> wutang1105
> ------------------------------------------------------------------------
> wutang1105's Profile:
http://www.excelforum.com/member.php...o&userid=26683
> View this thread: http://www.excelforum.com/showthread...hreadid=399547
>

It is an array formula, so after typing it, hit Ctrl-Shift-Enter together,
not just Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wutang1105" <[email protected]> wrote
in message news:[email protected]...
>
> Got this function from Excel Help but it gives me #Value error. Can
> anyone help?
>
>
>
>
>
> =SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))
>
> Number of invoices for Buchanan with a value less than 9,000. (1)
>
>
> --
> wutang1105
> ------------------------------------------------------------------------
> wutang1105's Profile:
http://www.excelforum.com/member.php...o&userid=26683
> View this thread: http://www.excelforum.com/showthread...hreadid=399547
>

It is an array formula, so after typing it, hit Ctrl-Shift-Enter together,
not just Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wutang1105" <[email protected]> wrote
in message news:[email protected]...
>
> Got this function from Excel Help but it gives me #Value error. Can
> anyone help?
>
>
>
>
>
> =SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))
>
> Number of invoices for Buchanan with a value less than 9,000. (1)
>
>
> --
> wutang1105
> ------------------------------------------------------------------------
> wutang1105's Profile:
http://www.excelforum.com/member.php...o&userid=26683
> View this thread: http://www.excelforum.com/showthread...hreadid=399547
>

It is an array formula, so after typing it, hit Ctrl-Shift-Enter together,
not just Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wutang1105" <[email protected]> wrote
in message news:[email protected]...
>
> Got this function from Excel Help but it gives me #Value error. Can
> anyone help?
>
>
>
>
>
> =SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))
>
> Number of invoices for Buchanan with a value less than 9,000. (1)
>
>
> --
> wutang1105
> ------------------------------------------------------------------------
> wutang1105's Profile:
http://www.excelforum.com/member.php...o&userid=26683
> View this thread: http://www.excelforum.com/showthread...hreadid=399547
>

It is an array formula, so after typing it, hit Ctrl-Shift-Enter together,
not just Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wutang1105" <[email protected]> wrote
in message news:[email protected]...
>
> Got this function from Excel Help but it gives me #Value error. Can
> anyone help?
>
>
>
>
>
> =SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))
>
> Number of invoices for Buchanan with a value less than 9,000. (1)
>
>
> --
> wutang1105
> ------------------------------------------------------------------------
> wutang1105's Profile:
http://www.excelforum.com/member.php...o&userid=26683
> View this thread: http://www.excelforum.com/showthread...hreadid=399547
>

It is an array formula, so after typing it, hit Ctrl-Shift-Enter together,
not just Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wutang1105" <[email protected]> wrote
in message news:[email protected]...
>
> Got this function from Excel Help but it gives me #Value error. Can
> anyone help?
>
>
>
>
>
> =SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))
>
> Number of invoices for Buchanan with a value less than 9,000. (1)
>
>
> --
> wutang1105
> ------------------------------------------------------------------------
> wutang1105's Profile:
http://www.excelforum.com/member.php...o&userid=26683
> View this thread: http://www.excelforum.com/showthread...hreadid=399547
>