lundi 11 juillet 2016

Using Excel to Sum Ranges of Cells That Meet Certain Criteria

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.Flare Data

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