Countif Function
Below is the table i'm working with
However i've look at the previous link fro countif function's and wasnt sure
how i could implememnt that for wat i need.
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
What i have to do is: use a countif function to count all discounts (being %
column). note the discounts have to be for the quarter. not yearly.....
Thankyou for any help
--
Enquirer
|