Hello everyone! I have a work sheet that various fields from A4 to F4 are stored. The columns go down to line 749, so entries can be from A4:F4 to A749:F749; each row is a single entry. I have Boxes to the left of this range and I want them to look for the value in The F column and if it’s true, add the value from the associating C column to an ongoing tally. I want this to work for the entire range, not just a particular line from it. It would be something like IF F4="F", L2=(L2+C4), L2=L2 I know that syntax isn’t correct, especially since that would only work with data from row 4. The Box that I’m putting the formula in is L2, so I want L2 to be a running tally of all data (rows 4 to 749) in column C (that’s the numeric value to be added to the running total) if the value of that row’s column F is equal to the letter F(the Value in the F column would either be an F or a G). I could keep putting items in my rows and if the F column field is the right value, it would keep increasing the total in my tally, which is F2. I have another box below it that is the same thing, but instead of just looking at the F column, I want it to look at two variables. I want that one to look for the value in the E column box and if the value is 1, then check to see if the letter F is in the F column box. If both of those conditions are true, then add it to a running tally in L6. I am sorry if I have been long winded and confusing, but I hope somebody can help me sort this out.
Bookmarks