Dear All,
I have a sumif function in a cell which adds values from a table from another sheet. When I apply a filter in the table, the sumif still includes the invisible rows. Is there a simple way to add only the visible rows with a function based on a criteria like with the sumif. i.e. after certain rows are not visible, still a further slection has to be made base don another cell in the same row.
Many thanks in advance.
Jazztech
I have a sumif function in a cell which adds values from a table from another sheet. When I apply a filter in the table, the sumif still includes the invisible rows. Is there a simple way to add only the visible rows with a function based on a criteria like with the sumif. i.e. after certain rows are not visible, still a further slection has to be made base don another cell in the same row.
Many thanks in advance.
Jazztech