I have an Excel sheet that contains 6,568 rows of data. For one of the columns, E, I am trying to create subtotals for all of the times that the flow rate drops below 5. I have included a screenshot as an example.
What am I trying to do is create a function that scans the entirety of column E and sums up the times (column A) for when the value of column E is below 5.
I thought I could do this when an IF statement, but I do not think that is the best way. Maybe "SUMIF", but I don't think that is right either. Is this something better suited for VBA?
This is what I started with:
IF(E2270<5, IF(E2271<5), blah blah blah)
I am a little stumped here though. Any help is appreciated.
Aucun commentaire:
Enregistrer un commentaire