Excel 2007 : Getting data in excel

Hi,

Please anyone help me out for getting the data in attached file.

I just need to fill the nos for a certain Loctaion (ex. "central", "Easteren") in a cell (provided in sheet -Column O, P Q).
pls solve out the data with the help of formuale only, pls don't use coding for the same.

Pls anyone help me out. Hope to hear someone soon.



Rgds
Workbook.xls

Hi,

Thanks for your prompt reply.
Its right, but i have not to assign the range to countif. I need to solve the same that if there is more data and there are two times a merge criterion, and then i need the same, I need some advance function that can automatically search the range for my criterion and then give me the result.

Hope u understand my query.



Rgds

Originally Posted by SCLai

Hope this is what you wanted then!

SC

Hi SC,

Thanks for your reply and the formula is working.
But there is a query within it. It couldn't take the data for second time and there is no result for that. Means it only count the desired nos only for ones, but when the field repeat itself after wards in range it counts only for top data only. For Ex. If i count for "Central" i.e in range B3:B8 and it revised itself in B50:B59, it counts "1" only for the simultaneous range of B3:B8 only not including others if contains.

Pls also let me know, in formulae what is the use of "?*" which u use here.

Hope to hear u soon.


Thanks
Ansh