Hi all,
I have been stuck at this for 2 days now. Hope someone can show me the way.
I have 2 worksheet namely 'D' and 'D1' (e.g. D being 18 may and D1 being 17 may)
I have some conditions that will be met, and the overall sumproduct of D will minus overall sumproduct of D1.
I would like to display those differences. (e.g. the '-1' highlighted in green in the formula worksheet)
please refer to attached sample.
sample1.xls
Bookmarks