COUNTIFS help

[sureshsonti]

I am trying to use COUNTIFS function to count the number of tickets based on dates and material and should show the number of tickets for each month for each material.

I have the main data in enter_data tab and what to extract the data to loads_qty to get number of LOADS for each month. In the enter_data tab each ticket is a LOAD.

Also on the invoice page how can I display data from enter_data tab. I want to extract

Date / Ticket / PLANT_MATERIAL_VENDOR / QTY / FREIGHT RATE / AMOUNT

the above data should be displayed based on the date range and the Hauler.

Thanks for your help

 

[Nebu]

Hi:

Can't you pull a pivot for this?

Thanks

 

[AliGW]

Is this what you are looking for?

=COUNTIFS(qty,"<>",date,">=" &0+("1/"&$A9),date,"<="&EOMONTH(0+("1/"&$A9),0),matls,$B$1)

 

[sureshsonti]

Yes. That's the formula. It worked. Thanks for your help

 

[sureshsonti]

Hi:

Can't you pull a pivot for this?

Thanks

Thanks for your help. Trying to avoid hitting refresh button each time data is entered. My boss doesnt know how to do that.

 

[AliGW]

Glad to have helped!

 

[pecoflyer]

Thanks for your help. Trying to avoid hitting refresh button each time data is entered. My boss doesnt know how to do that.

But you could add a small macro that refreshes the PT each time the sheet is accessed...
You can find it easily on the Net

 

[sureshsonti]

Ok. Let me try the macro. Will let you know the outcome. Thanks for your help