COUNTIF + Month

[Phendrena]

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

 

[Roger Govier]

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.

 

[Phendrena]

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.

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

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

 

[Roger Govier]

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

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.

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

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

 

[Phendrena]

Thank you for the reply,

That formula has worked nicely. Excellent!!!

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

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.

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



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