I have a spreadsheet we use as a Call Report. The report includes a
calendar year. I need to add up some data based on quarters of the year.

Column A is the Date Column. If the date in col A is between Jan 1 and Mar
31, I need to add up the number of times column B has an Alpha entry like
the letter H.

Is that possible?

TIA
--
Tom

On Mon, 09 Jun 2008 10:54:18 -0400, Tom wrote:

I have a spreadsheet we use as a Call Report. The report includes a
calendar year. I need to add up some data based on quarters of the year.

Column A is the Date Column. If the date in col A is between Jan 1 and Mar
31, I need to add up the number of times column B has an Alpha entry like
the letter H.

Is that possible?

TIA


Assuming that your cata in column A is data values and not text you
can try this function to get the number of hits:

=SUMPRODUCT((MONTH(A1:A1000)=1)*(MONTH(A1:A1000)< =3)*(B1:B1000="H"))

Change the 1000 to cover the rows with data in your case

Hope this helps. / Lars-Åke

On Mon, 09 Jun 2008 16:05:02 GMT, Lars-Åke Aspelin
wrote:

On Mon, 09 Jun 2008 10:54:18 -0400, Tom wrote:

I have a spreadsheet we use as a Call Report. The report includes a
calendar year. I need to add up some data based on quarters of the year.

Column A is the Date Column. If the date in col A is between Jan 1 and Mar
31, I need to add up the number of times column B has an Alpha entry like
the letter H.

Is that possible?

TIA


Assuming that your cata in column A is data values and not text you
can try this function to get the number of hits:

=SUMPRODUCT((MONTH(A1:A1000)=1)*(MONTH(A1:A1000) <=3)*(B1:B1000="H"))

Change the 1000 to cover the rows with data in your case

Hope this helps. / Lars-Åke


cata - data
is - are

Yes thanks! This formula did the trick! Appreciate your reply!

Tom


On Mon, 09 Jun 2008 16:05:02 GMT, Lars-Åke Aspelin
wrote:

On Mon, 09 Jun 2008 10:54:18 -0400, Tom wrote:

I have a spreadsheet we use as a Call Report. The report includes a
calendar year. I need to add up some data based on quarters of the year.

Column A is the Date Column. If the date in col A is between Jan 1 and Mar
31, I need to add up the number of times column B has an Alpha entry like
the letter H.

Is that possible?

TIA


Assuming that your cata in column A is data values and not text you
can try this function to get the number of hits:

=SUMPRODUCT((MONTH(A1:A1000)=1)*(MONTH(A1:A1000) <=3)*(B1:B1000="H"))

Change the 1000 to cover the rows with data in your case

Hope this helps. / Lars-Åke
--
Tom