Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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%") |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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%") |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif help | Excel Worksheet Functions | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |