SumIf Question

[Tom]

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

 

[Lars-Åke Aspelin]

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

 

[Lars-Åke Aspelin]

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

 

[Tom]

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

Tom