|
|
|
date: Wed, 3 Sep 2008 11:51:18 +0100,
group: microsoft.public.excel.worksheet.functions
back
Re: sumif? countif?
You can only use COUNTIF (and SUMIF) if there is only one condition.
Try this instead:
=SUMPRODUCT((mar!B1:B100=Brokers!A3)*(mar!M1:M100="y"))
Note that you can't use full-column references (unless you have
XL2007), so adjust the ranges to suit.
Hope this helps.
Pete
On Sep 3, 11:51 am, "Aaron Hodson \(Coversure\)"
wrote:
> Hello,
>
> I need some help with the following:
>
> I require cell K3 (in worksheet named 'brokers') to count the number of
> times the data in A3 matches those in mar!B:B.
> I have acheived this by using formula: =COUNTIF(mar!B:B,Brokers!A:A)
>
> However, i now need to insert another arguement, where in addition to the
> above, only count if mar!M:M contains the letter 'y'.
>
> Please help,
>
> Thanks
>
> Aaron
date: Wed, 3 Sep 2008 04:48:01 -0700 (PDT)
author: Pete_UK
Re: sumif? countif?
Works perfectly!
Thank you very much for your help.
"Pete_UK" wrote in message
news:87af5b2b-b290-477e-8456-78b4b82b231d@j22g2000hsf.googlegroups.com...
You can only use COUNTIF (and SUMIF) if there is only one condition.
Try this instead:
=SUMPRODUCT((mar!B1:B100=Brokers!A3)*(mar!M1:M100="y"))
Note that you can't use full-column references (unless you have
XL2007), so adjust the ranges to suit.
Hope this helps.
Pete
On Sep 3, 11:51 am, "Aaron Hodson \(Coversure\)"
wrote:
> Hello,
>
> I need some help with the following:
>
> I require cell K3 (in worksheet named 'brokers') to count the number of
> times the data in A3 matches those in mar!B:B.
> I have acheived this by using formula: =COUNTIF(mar!B:B,Brokers!A:A)
>
> However, i now need to insert another arguement, where in addition to the
> above, only count if mar!M:M contains the letter 'y'.
>
> Please help,
>
> Thanks
>
> Aaron
date: Wed, 3 Sep 2008 14:45:48 +0100
author: Aaron Hodson \(Coversure\)
|
|
