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