|
COUNTIF + Month
Hi,
I have date ranges in column B (B3:B503) If the month in the date ranges is a specific month then i need to count up the data placed in Column G (G3:G503). =COUNTIF('[Name.xls]Mid-Term'!$G$3:$G$503,'[Name.xls]Mid-Term'!$B$3:$B$503) Now i'm not very familiar with many of the functions within excel, so can anyone suggest how to complete the above formula. Thanks, Phendrena |
COUNTIF + Month
Hi
I am assuming that you mean you wish to Sum the values in Colum G If so, then try =SUMPRODUCT(--(MONTH('[Name.xls]Mid-Term'!$B$3:$B$503)=1), '[Name.xls]Mid-Term'!$G$3:$G$503) where the 1 in the formula represents January. Change for other months. Alternatively put the month number in a cell, and insert that cell reference into the formula in place of the number 1. -- Regards Roger Govier "Phendrena" wrote in message ... Hi, I have date ranges in column B (B3:B503) If the month in the date ranges is a specific month then i need to count up the data placed in Column G (G3:G503). =COUNTIF('[Name.xls]Mid-Term'!$G$3:$G$503,'[Name.xls]Mid-Term'!$B$3:$B$503) Now i'm not very familiar with many of the functions within excel, so can anyone suggest how to complete the above formula. Thanks, Phendrena |
COUNTIF + Month
thanks for the response, the values in column G are also text values so i
just need it to count as long as there is text in there. "Roger Govier" wrote: Hi I am assuming that you mean you wish to Sum the values in Colum G If so, then try =SUMPRODUCT(--(MONTH('[Name.xls]Mid-Term'!$B$3:$B$503)=1), '[Name.xls]Mid-Term'!$G$3:$G$503) where the 1 in the formula represents January. Change for other months. Alternatively put the month number in a cell, and insert that cell reference into the formula in place of the number 1. -- Regards Roger Govier "Phendrena" wrote in message ... Hi, I have date ranges in column B (B3:B503) If the month in the date ranges is a specific month then i need to count up the data placed in Column G (G3:G503). =COUNTIF('[Name.xls]Mid-Term'!$G$3:$G$503,'[Name.xls]Mid-Term'!$B$3:$B$503) Now i'm not very familiar with many of the functions within excel, so can anyone suggest how to complete the above formula. Thanks, Phendrena |
COUNTIF + Month
Hi
Then use =SUMPRODUCT(--(MONTH('[Name.xls]Mid-Term'!$B$3:$B$503)=1), --('[Name.xls]Mid-Term'!$G$3:$G$503<"")) -- Regards Roger Govier "Phendrena" wrote in message ... thanks for the response, the values in column G are also text values so i just need it to count as long as there is text in there. "Roger Govier" wrote: Hi I am assuming that you mean you wish to Sum the values in Colum G If so, then try =SUMPRODUCT(--(MONTH('[Name.xls]Mid-Term'!$B$3:$B$503)=1), '[Name.xls]Mid-Term'!$G$3:$G$503) where the 1 in the formula represents January. Change for other months. Alternatively put the month number in a cell, and insert that cell reference into the formula in place of the number 1. -- Regards Roger Govier "Phendrena" wrote in message ... Hi, I have date ranges in column B (B3:B503) If the month in the date ranges is a specific month then i need to count up the data placed in Column G (G3:G503). =COUNTIF('[Name.xls]Mid-Term'!$G$3:$G$503,'[Name.xls]Mid-Term'!$B$3:$B$503) Now i'm not very familiar with many of the functions within excel, so can anyone suggest how to complete the above formula. Thanks, Phendrena |
COUNTIF + Month
Thank you for the reply,
That formula has worked nicely. Excellent!!! "Roger Govier" wrote: Hi Then use =SUMPRODUCT(--(MONTH('[Name.xls]Mid-Term'!$B$3:$B$503)=1), --('[Name.xls]Mid-Term'!$G$3:$G$503<"")) -- Regards Roger Govier "Phendrena" wrote in message ... thanks for the response, the values in column G are also text values so i just need it to count as long as there is text in there. "Roger Govier" wrote: Hi I am assuming that you mean you wish to Sum the values in Colum G If so, then try =SUMPRODUCT(--(MONTH('[Name.xls]Mid-Term'!$B$3:$B$503)=1), '[Name.xls]Mid-Term'!$G$3:$G$503) where the 1 in the formula represents January. Change for other months. Alternatively put the month number in a cell, and insert that cell reference into the formula in place of the number 1. -- Regards Roger Govier "Phendrena" wrote in message ... Hi, I have date ranges in column B (B3:B503) If the month in the date ranges is a specific month then i need to count up the data placed in Column G (G3:G503). =COUNTIF('[Name.xls]Mid-Term'!$G$3:$G$503,'[Name.xls]Mid-Term'!$B$3:$B$503) Now i'm not very familiar with many of the functions within excel, so can anyone suggest how to complete the above formula. Thanks, Phendrena |
| All times are GMT +1. The time now is 04:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com