ashish navale
New Member
Hi..
I have a Tracker where I have to update the daily request processed under US or UK. In column A there is date(dd-mmm-yy), In column B there is request id(eg.1-12345678), In column C there is country data..i.e., UK or US. In the same workbook I have made a different sheet named Service request Count.
Now this sheet will show count of daily request processed...i.e count of column B as with reference to country..i.e. Uk/US. But I m unable to prepare the formula for it..there are two functions..."Sumproduct" and other "countif"...
Could you plz help me out which formula will be more useful...also could you show me how the formula will be? Plz help me out with this query..as its the big hurdle for me..ur help is appreciated...
I have a Tracker where I have to update the daily request processed under US or UK. In column A there is date(dd-mmm-yy), In column B there is request id(eg.1-12345678), In column C there is country data..i.e., UK or US. In the same workbook I have made a different sheet named Service request Count.
Now this sheet will show count of daily request processed...i.e count of column B as with reference to country..i.e. Uk/US. But I m unable to prepare the formula for it..there are two functions..."Sumproduct" and other "countif"...
Could you plz help me out which formula will be more useful...also could you show me how the formula will be? Plz help me out with this query..as its the big hurdle for me..ur help is appreciated...