CountIF
 

I'm currently in the middle of an assignment and have hit a cropper with a
COUNTIF function.... we have to use the COUNTIF function... Below is the
table i'm working with:
Discount Status April Sales May Sales June
Sales
10% Custom $50,023.00 $50,023.00 $50,023.00
14% Key $110,353.00 $112,000.00 $112,300.00
5% Custom $48,201.00 $110,353.00 $95,820.00
14% Key $112,000.00 $23,340.00 $72,000.00
We are expected to use a countif function to count all discounts for each
month based on there amount. If some one could do an example of a countif for
the april sales of $48,201.00 for 5%. Once i had the idea i would attempt the
rest myself.... any help please???????


--
Enquirer

CountIF
 

On Jun 13, 11:46*am, pejy69 wrote:
I'm currently in the middle of an assignment and have hit a cropper with a
COUNTIF function.... we have to use the COUNTIF function... Below is the
table i'm working with:
Discount * * * *Status *April Sales * * * * * * * * * * May Sales * * * * * * * * * * * June
Sales
10% * * Custom *$50,023.00 * * *$50,023.00 * * *$50,023.00
14% * * Key * * $110,353.00 * * $112,000.00 * * $112,300.00
5% * * *Custom *$48,201.00 * * *$110,353.00 * * $95,820.00
14% * * Key * * $112,000.00 * * $23,340.00 * * *$72,000.00
We are expected to use a countif function to count all discounts for each
month based on there amount. If some one could do an example of a countif for
the april sales of $48,201.00 for 5%. Once i had the idea i would attempt the
rest myself.... any help please???????

--
Enquirer

Dude,

You need to read the help on the functions available in excel first.

anyways something like the following will work:
=COUNTIF(A2:A5,"5%")

CountIF
 

To be honest i dont find the help menu of formulas to be of much
assistance.....
The sum you gave me doesnt work as it's per cell, not a range of cells.
EG: the table below shows the sales for april and then the discount they are
entitled to... thats all we need per month.... thats why i'm confused as the
help menu doesnt help much

--
Enquirer


"Nayab" wrote:

On Jun 13, 11:46 am, pejy69 wrote:
I'm currently in the middle of an assignment and have hit a cropper with a
COUNTIF function.... we have to use the COUNTIF function... Below is the
table i'm working with:
Discount Status April Sales May Sales June
Sales
10% Custom $50,023.00 $50,023.00 $50,023.00
14% Key $110,353.00 $112,000.00 $112,300.00
5% Custom $48,201.00 $110,353.00 $95,820.00
14% Key $112,000.00 $23,340.00 $72,000.00
We are expected to use a countif function to count all discounts for each
month based on there amount. If some one could do an example of a countif for
the april sales of $48,201.00 for 5%. Once i had the idea i would attempt the
rest myself.... any help please???????

--
Enquirer

Dude,

You need to read the help on the functions available in excel first.

anyways something like the following will work:
=COUNTIF(A2:A5,"5%")

CountIF
 

On Jun 13, 4:03*pm, pejy69 wrote:
To be honest i dont find the help menu of formulas to be of much
assistance.....
The sum you gave me doesnt work as it's per cell, not a range of cells.
EG: the table below shows the sales for april and then the discount they are
entitled to... thats all we need per month.... thats why i'm confused as the
help menu doesnt help much

--
Enquirer



"Nayab" wrote:
On Jun 13, 11:46 am, pejy69 wrote:
I'm currently in the middle of an assignment and have hit a cropper with a
COUNTIF function.... we have to use the COUNTIF function... Below is the
table i'm working with:
Discount * * * *Status *April Sales * * * * * * * * * * May Sales * * * * * * * * * * * June
Sales
10% * * Custom *$50,023.00 * * *$50,023.00 * * *$50,023.00
14% * * Key * * $110,353.00 * * $112,000.00 * * $112,300.00
5% * * *Custom *$48,201.00 * * *$110,353.00 * * $95,820.00
14% * * Key * * $112,000.00 * * $23,340.00 * * *$72,000.00
We are expected to use a countif function to count all discounts for each
month based on there amount. If some one could do an example of a countif for
the april sales of $48,201.00 for 5%. Once i had the idea i would attempt the
rest myself.... any help please???????

--
Enquirer

Dude,

You need to read the help on the functions available in excel first.

anyways something like the following will work:
=COUNTIF(A2:A5,"5%")- Hide quoted text -

- Show quoted text -

I am not clear on wat exactly is your requirement. Do u want to know
the discount/sales amount sum? If u have to do a sum then u need to
sumif and not countif