Formula for sum of values which meet certain conditions

[PetaRu]

Any ideas on how to write a formula to find the following value:
I have 3 columns:
- A is a number value (from 0 to 100)
- B is a text value (i.e. “sheep”)
- C is a date
I want to calculate the total sum of the values in Column A for rows that has a specific text value in column B (i.e "sheep") and are within a specific date range in column C (i.e. between 1st July 18 and 31st July 19). Is this possible?

[alansidman]

Look to use the =Sumifs function. Here is a link to help you.

https://www.techonthenet.com/excel/formulas/sumifs.php

[FDibbins]

Try this...
=sumifs(A:A,B:B,"sheep",C:C,">=7/1/2019",C:C,"<=7/31/2019")