Re: Want To Count With Two Criteria

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Bob Phillips (bob.phillips_at_notheretiscali.co.uk)
Date: 08/23/04

Next message: michelle: "i can't find the answer anywhere!"
Previous message: Jason.Morin: "Re: How to determine formula or simple value in a cell?"
In reply to: AAK1697: "Re: Want To Count With Two Criteria"
Next in thread: AAK1697: "Re: Want To Count With Two Criteria"
Reply: AAK1697: "Re: Want To Count With Two Criteria"
Messages sorted by: [ date ] [ thread ]

Date: Mon, 23 Aug 2004 21:18:19 +0100

=sumproduct(--(a2:a200="G"),--(c2:c200="OSI"),b2:b200)

-- 
HTH
Bob Phillips
    ... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"AAK1697 >" <<AAK1697.1bgiov@excelforum-nospam.com> wrote in message
news:AAK1697.1bgiov@excelforum-nospam.com...
> THANK YOU.  IT WORKED!  ONE MORE THING....HOW WOULD I SUM THE ACCOUNTS
> THAT MET THE SAME CRITERIA?
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

Next message: michelle: "i can't find the answer anywhere!"
Previous message: Jason.Morin: "Re: How to determine formula or simple value in a cell?"
In reply to: AAK1697: "Re: Want To Count With Two Criteria"
Next in thread: AAK1697: "Re: Want To Count With Two Criteria"
Reply: AAK1697: "Re: Want To Count With Two Criteria"
Messages sorted by: [ date ] [ thread ]