CountIF

[pejy69]

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???????

 

[Nayab]

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???????

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%")

 

[pejy69]

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

 

[Nayab]

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






- 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