In column C it should tally the number in row 3
for lines that are highlighted green.
For example in row 17, the Tally in column C is 24
because the 4 green cells in row 17 are adding the
QTY above it in ROW 3.
If a date in a line cell is not highlighted green it
should not be included in the tally (column C)
For your reference in column C the tally has been
manually calculated to show what the forumula should
4 freelanceria on tarjonnut keskimäärin 21$ tähän työhön
I am a professional with a decade of experience working in a US based NASDAQ registered company with all the knowledge and skills required for your project. Please send me a message and we can start working.
i can do this. i have good command over Ms excel especially pivot table, charts, advance formulas, formatting, macro etc. Please inbox me and share detail. Thanks