PaulFogel123
Member
Hello,
Attached is a sample database (a Pivot Table) and summary table below it. I got some expert help on this forum to figure out the correct INDEX/MATCH formula. Now I wish to add a condition to the formula. Row 3 contains a TRUE/FALSE field. TRUE means the data is ready to load; FALSE means it isn't ready and the summary table should return zero. I want my formulas to distinguish between TRUE and FALSE without using a specific cell reference.
I have used a formula like this: OR((B2 : P2=E10)*B3 : P3) before, and it returns TRUE or FALSE, but it doesn't work here and I don't know why. What is the solution?
Thank you, Paul
Attached is a sample database (a Pivot Table) and summary table below it. I got some expert help on this forum to figure out the correct INDEX/MATCH formula. Now I wish to add a condition to the formula. Row 3 contains a TRUE/FALSE field. TRUE means the data is ready to load; FALSE means it isn't ready and the summary table should return zero. I want my formulas to distinguish between TRUE and FALSE without using a specific cell reference.
I have used a formula like this: OR((B2 : P2=E10)*B3 : P3) before, and it returns TRUE or FALSE, but it doesn't work here and I don't know why. What is the solution?
Thank you, Paul
Last edited by a moderator: