|
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 |
Countif Function
Hi,
From the table below what answer do you expect to get? Mike "pejy69" wrote: 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 |
Countif Function
Custom and key discounts for the Quarter. i presume the quarter being april,
may & June -- Enquirer "Mike H" wrote: Hi, From the table below what answer do you expect to get? Mike "pejy69" wrote: 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 |
Countif Function
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" wrote in message ... Custom and key discounts for the Quarter. i presume the quarter being april, may & June -- Enquirer "Mike H" wrote: Hi, From the table below what answer do you expect to get? Mike "pejy69" wrote: 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 |
Countif Function
Sorry all
The details i have in front of me a 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. -- Enquirer "Bob Phillips" wrote: 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" wrote in message ... Custom and key discounts for the Quarter. i presume the quarter being april, may & June -- Enquirer "Mike H" wrote: Hi, From the table below what answer do you expect to get? Mike "pejy69" wrote: 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 |
Countif Function
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 "pejy69" wrote: Sorry all The details i have in front of me a 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. -- Enquirer "Bob Phillips" wrote: 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" wrote in message ... Custom and key discounts for the Quarter. i presume the quarter being april, may & June -- Enquirer "Mike H" wrote: Hi, From the table below what answer do you expect to get? Mike "pejy69" wrote: 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 |
Countif Function
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" wrote in message ... 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 "pejy69" wrote: Sorry all The details i have in front of me a 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. -- Enquirer "Bob Phillips" wrote: 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" wrote in message ... Custom and key discounts for the Quarter. i presume the quarter being april, may & June -- Enquirer "Mike H" wrote: Hi, From the table below what answer do you expect to get? Mike "pejy69" wrote: 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 |
Countif Function
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:) "Bob Phillips" wrote: 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" wrote in message ... 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 "pejy69" wrote: Sorry all The details i have in front of me a 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. -- Enquirer "Bob Phillips" wrote: 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" wrote in message ... Custom and key discounts for the Quarter. i presume the quarter being april, may & June -- Enquirer "Mike H" wrote: Hi, From the table below what answer do you expect to get? Mike "pejy69" wrote: 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 |
Countif Function
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 -- Enquirer "Mike H" wrote: 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:) "Bob Phillips" wrote: 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" wrote in message ... 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 "pejy69" wrote: Sorry all The details i have in front of me a 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. -- Enquirer "Bob Phillips" wrote: 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" wrote in message ... Custom and key discounts for the Quarter. i presume the quarter being april, may & June -- Enquirer "Mike H" wrote: Hi, From the table below what answer do you expect to get? Mike "pejy69" wrote: 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 |
| All times are GMT +1. The time now is 05:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com