Count Feedings per Shift
I need to count how many times 'Baby Smith' was fed where 'Amount' was > 50ml.
=COUNTIFS(B2:B9,"Baby Smith",C2:C9,">50") How it works: The COUNTIFS function is used to count cells that meet multiple criteria. In this scenario, it first looks in the range B2:B9 for all instances of 'Baby Smith'. Then, for those same rows, it checks the corresponding cells in the range C2:C9 to see if the 'Feeding Amount (ml)' is greater than 50. Only rows that satisfy both conditions are included in the final count, providing a precise tally of specific feeding events.
Data Setup
| Date | Baby Name | Feeding Amount (ml) | Notes |
|---|---|---|---|
| 2023-10-26 08:00 | Baby Smith | 60 | Formula |
| 2023-10-26 09:30 | Baby Jones | 45 | Breastmilk |
| 2023-10-26 10:00 | Baby Smith | 70 | Formula |
| 2023-10-26 11:00 | Baby Doe | 55 | Formula |
| 2023-10-26 12:00 | Baby Smith | 40 | Breastmilk |
| 2023-10-26 13:00 | Baby Smith | 80 | Formula |
| 2023-10-26 14:00 | Baby Jones | 65 | Formula |
| 2023-10-26 15:00 | Baby Smith | 55 | Formula |
Step-by-Step Guide
Open your Excel spreadsheet containing the feeding log data.
Identify the column that contains the 'Baby Name' (e.g., Column B) and the column for 'Feeding Amount (ml)' (e.g., Column C).
Select an empty cell where you want the result to appear.
Type the formula: `=COUNTIFS(B2:B9,"Baby Smith",C2:C9,">50")`
Press Enter to get the total count of feedings for 'Baby Smith' where the amount was greater than 50ml.