I'm struggling with an Excel spreadsheet that contains 91 rows. What I’m trying to do is:
Sum all rows in Column G when Column B=.0001 and Column E=1 within the same row. In other words, only add cells in Column G if, within that same row, Column B=.0001 and E-1.
Make sense?
Can anyone provide me an example of the formula I should use?
Thanks!
Sum all rows in Column G when Column B=.0001 and Column E=1 within the same row. In other words, only add cells in Column G if, within that same row, Column B=.0001 and E-1.
Make sense?
Can anyone provide me an example of the formula I should use?
Thanks!