Counting occurrences in a specified range and date

[kebabpete]

I'm currently using... =SUMPRODUCT((Quantity)*(MONTH(Date)=7)*(Adjustment_Type="Booking In Error"))

... to calculate the sum of a column based on a specified date range (MONTH(Date)=7) and also based on a specific criteria (Adjustment_Type).

Instead of finding the sum of the 'Quantity', can someone tell me what change to make to this formula to only count the number of occurrences within the same criteria?

Assume...
Column A = 'Adjustment Type'
Column B = 'Quantity'
Column C = 'Date'

Thanks!

 

[scottylad2]

What version do you have? If 2007 or later try the Countifs formula, if i'm reading your formula correct just lose the quantity part from what you already have, or replace with Quantity<>"" which will make a count everytime theres a number in that colum wher the criterias met, if the default is 0 in the cell, swap the "" for >o

 

[kebabpete]

Hmmm, May have confused myself a bit now. Using 2007... Have just tried... =COUNTIFS("<>",Month(Date)=7,">0",Adjustment_Type="Despatch Error"). If I remove the ">0" then there is too few arguments.

 

[lundbhaiz]

I'm currently using... =SUMPRODUCT((Quantity)*(MONTH(Date)=7)*(Adjustment_Type="Booking In Error"))

... to calculate the sum of a column based on a specified date range (MONTH(Date)=7) and also based on a specific criteria (Adjustment_Type).

Instead of finding the sum of the 'Quantity', can someone tell me what change to make to this formula to only count the number of occurrences within the same criteria?

Assume...
Column A = 'Adjustment Type'
Column B = 'Quantity'
Column C = 'Date'

Thanks!

your formula will give count with your specified criteria if you just remove the sum range at end in your sumproduct formula

 

[Marcelo Branco]

I'm currently using... =SUMPRODUCT((Quantity)*(MONTH(Date)=7)*(Adjustment_Type="Booking In Error"))

... to calculate the sum of a column based on a specified date range (MONTH(Date)=7) and also based on a specific criteria (Adjustment_Type).

Instead of finding the sum of the 'Quantity', can someone tell me what change to make to this formula to only count the number of occurrences within the same criteria?

Assume...
Column A = 'Adjustment Type'
Column B = 'Quantity'
Column C = 'Date'

Thanks!

Try
=SUMPRODUCT((MONTH(Date)=7)*(Adjustment_Type="Booking In Error"))

M.

 

[kebabpete]

Try
=SUMPRODUCT((MONTH(Date)=7)*(Adjustment_Type="Booking In Error"))

M.

Nailed it! Thanks for that.