I have a spreadsheet with multiple tabs label with a month/year(July 2023). These sheets have data and formulas to calculate a dollar amount.
=@INDIRECT($A$1&"C"&(ROW()-3)*7+4)
this formula is in another tab where in I enter the tab name (month/year) in cell A1 I want to pull certain data from. It pulls the correct information however I would like to add a filter function so only pulls the data for the dollar amount > 0
Hopefully I have explained this well enough. I have included an image if it helps.
Thanks for any help provided.
=@INDIRECT($A$1&"C"&(ROW()-3)*7+4)
this formula is in another tab where in I enter the tab name (month/year) in cell A1 I want to pull certain data from. It pulls the correct information however I would like to add a filter function so only pulls the data for the dollar amount > 0
Hopefully I have explained this well enough. I have included an image if it helps.
Thanks for any help provided.