Hi everyone
I have this table below, I used an index/match array formula for two columns of criteria, to display the totals for all the week 5's and display the totals in another sheet. But now I need to a formula to display any of the weeks total's that are greater than zero and excluding week 5. Is there a way to make wither a vlookup or an index/match function to exclude criteria/data???
PERSON WEEK TOTAL
MRS.TW 5 20
MR.ONE 1 0
MR.ONE 2 0
MR.ONE 5 40
MR.ONE 26 0
MR.THRE 3 5
MR.THRE 5 40
MR.R 4 3
MR.R 5 10
MR.R 1 3
MRS.FOU 4 30
MRS.FOU 3 5
MRS.FOU 5 40
MR.SEVE 5 40
MRS.TEN 5 40
MRS.TEN 1 15
MRS.TEN 20 2
MR.ELEV 3 4
MR.ELEV 1 0
MR.ELEV 5 25
MR.ELEV 4 7
Thank You
MZing81
Bookmarks