The actual worksheet I am using is coming from different worksheets. I noticed that your formula has blank cells in it "_". Is there a way we can make the formula simplified like the newer one provided without referencing the blank cells?

---------- Post added at 03:26 PM ---------- Previous post was at 03:24 PM ----------

If I had to do the calculation on another page, I need the formula to work