SumIf Question

  • Thread starter Thread starter Tom
  • Start date Start date
T

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
 
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
Click to expand...


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
 
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
Click to expand...


cata -> data
is -> are
 
Back
Top