I want to thak you all for helping me firgure out the formula for TOTAL in a database. But now I have another challenge for you all. The formula for total in a database on certain rows was =MATCH(REPT("z",255),$A$3:$A$914) - ROW(A$2)+1, but when I filter some rows it still shows the total of the orinignal database. How can I get the total of the ones that I filter? from row A3 to whatever row = total in this would happen if I filter certain date.
Bookmarks