Countif Function

[pejy69]

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

 

[Mike H]

Hi,

From the table below what answer do you expect to get?

Mike

 

[pejy69]

Custom and key discounts for the Quarter. i presume the quarter being april,
may & June

 

[Bob Phillips]

Give an example of what you expect in terms of that data, your explanation
explains nothing (to me at least).

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[pejy69]

Sorry all
The details i have in front of me are:
Use a countif function to count all discounts.
I belive i have to get the discount of 50,023.00 + 50,023.00 + 50,023.00 *
10% for te custom quarter. Then apply the same sort of thing to the 14% key
discount and so on.... i dont know how else to explain it, i hope that has
helped as i really need help....... if not i'm sorry, i dont really know what
else to add.

 

[Mike H]

I'm still confused but taking you literally to work out the discount doesn't
require Sumif. Try this and drag down

=SUM(C1:E1)*A1

Mike

 

[Bob Phillips]

He use 50%,50%,10% in the example Mike,so your formula doesn't look like the
solution, but like you I still have no idea what the requirement is.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Mike H]

I'm sure your right but I was rather hoping it would illicit a response along
the lines of " No that's wrong the answer should be......"

Looks like no points for this homework assignment

 

[pejy69]

Its assignment based question so i only have the information in front of me
that i can give you....... They have stated it has to be a COUNTIF... we are
required to use the COUNTIF to ascertain the monthly discounts....sorry i
cant give you more but it's all the info i have