what is the function name for this calculations

plz help me experts,... i am new to excel.
i am in animal husbandry department of punjab.
i am attaching a xlsx sheet here . it is a example . as shown in the sheet .....

numbers of semen strws(pipes of sperms for pregnent to cows and buffaloes) distribute to different towns.in a year 1-4-2011 to 31-12-2012
MY main question is that .
i want the total of straws for Amritsar in sheet 1
and total of straws for Tarn Taran in sheet 3
Total of straws for ludhiana in sheet 4....
and so on................................
plz tell me that what is the function name to do this .

and detail for apply to this...
PLZ PLZ help me ..........
thanks in advance

Vishesh's picture

Solution

You can use Countif or Countifs