How do I count a value if another field = a specific value? Excel

[AprilCarter]

I'm trying to count a specific value only if another column has a specific
value.

If column B=blue AND column I=App then count it.

I'm sure it's simple but I can't seem to find a function to make it work...
and I can't get the nested functions to work either...

April

[Anne Troy]

Try this, April:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"AprilCarter" <[email protected]> wrote in message
news:[email protected]...
> I'm trying to count a specific value only if another column has a specific
> value.
>
> If column B=blue AND column I=App then count it.
>
> I'm sure it's simple but I can't seem to find a function to make it
> work...
> and I can't get the nested functions to work either...
>
> April

[AprilCarter]

THAT WORKS PERFECTLY!!! THANK YOU SO MUCH!

"Anne Troy" wrote:

> Try this, April:
> http://www.officearticles.com/excel/...soft_excel.htm
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "AprilCarter" <[email protected]> wrote in message
> news:[email protected]...
> > I'm trying to count a specific value only if another column has a specific
> > value.
> >
> > If column B=blue AND column I=App then count it.
> >
> > I'm sure it's simple but I can't seem to find a function to make it
> > work...
> > and I can't get the nested functions to work either...
> >
> > April
>
>
>

[Anne Troy]

You're welcome!
************
Anne Troy
www.OfficeArticles.com

"AprilCarter" <[email protected]> wrote in message
news:[email protected]...
> THAT WORKS PERFECTLY!!! THANK YOU SO MUCH!
>
> "Anne Troy" wrote:
>
>> Try this, April:
>> http://www.officearticles.com/excel/...soft_excel.htm
>> ************
>> Anne Troy
>> www.OfficeArticles.com
>>
>> "AprilCarter" <[email protected]> wrote in message
>> news:[email protected]...
>> > I'm trying to count a specific value only if another column has a
>> > specific
>> > value.
>> >
>> > If column B=blue AND column I=App then count it.
>> >
>> > I'm sure it's simple but I can't seem to find a function to make it
>> > work...
>> > and I can't get the nested functions to work either...
>> >
>> > April
>>
>>
>>