Hello, me again! You all were very helpful over the weekend so hoping you can help me with this as well.
I've hidden some rows, but here is my spreadsheet:
I need to be able to:
- Calculate the sum of Gross Revenue (K)
- But only when D = NP
- And I need it to calculate only visible rows, so that if I filter by a date, it will only show results for that date.
Can anyone help?
I've hidden some rows, but here is my spreadsheet:
I need to be able to:
- Calculate the sum of Gross Revenue (K)
- But only when D = NP
- And I need it to calculate only visible rows, so that if I filter by a date, it will only show results for that date.
Can anyone help?