COUNTIFS based on 3 conditions

[sureshsonti]

I have an excel file with a table and named ranges

Table Fields (Date / Tickets / Hauler / Products / Plant / Qty / Freight Rate / Amt

1. I have to count the number of tickets based on a date range, hauler, product, and plant

2. Count the number of tickets for a product at different plants for each month

I have attached the spreadsheet

Thanks for your help

 

[Hui]

M6: =COUNTIFS(date,">="&$K$3,date,"<="&$L$3,hauler,$N$3,product,K6)
copy down

K19: =SUMPRODUCT((data[Plant]=K$17)*(data[Products]=K$18)*(TEXT(data[Date],"mmm")=$J19))
copy down and across

 

[sureshsonti]

Thanks Mr. Hui. The 2 formulas worked great. Really appreciate your help