View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pejy69 pejy69 is offline
external usenet poster
 
Posts: 8
Default 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