For the SUMIFS function, the first argument is the range of numbers to be summed, and the remaining arguments are all pairs of cell ranges and criteria. For example, to find the total number of Brown Trout in Albany county, try typing the following formula into cell G2:
=SUMIFS(D:D, A:A, "Albany", E:E, "Brown Trout")