Assume date wise revenue data has been shown on two sheets – Sports wear and Fitness equipment (Data worksheets). On each of these two worksheets, there are two columns – Date and Revenue. On the Summary worksheet, the user would like to summarise data (Count instances and sum revenue figures) based on multiple conditions. The […]
Read More →
Summarise data from multiple sheets with multiple conditions – Part II
{ 64 Comments }