Aravind (@arvindnatarajan) who works at Zoho emailed me earlier today and asked if Zoho Reports – Online Reporting and Business Intelligence Service, can sponsor our visualization challenge #2.
I couldn’t be happier to see that mail. Zoho is a perfect sponsor for a contest like this. If you haven’t heard of it, Zoho is a very popular online office solution. They have a collection of over 20 different productivity applications including zoho sheet, writer, show, projects, CRM, reports and much more. Check out more about online reporting and BI services on the Zoho Reports page.
What are you waiting for? Go ahead and take part in the contest, download the data and get charting.
2 Responses to “Celebrating the Lookup Formulas – VLOOKUP Week @ Chandoo.org”
How did you arrive or formula when you ask me who made more sales Jackie or Jamie?? I could not figure the formula out yet??
@Frank
You need to sum up the sales for Jackie and compare them to the sales of Jamie over the same period.
The practical parts depends on how and what data you have and how it is arranged.
But it will either involve a Sum, Sumif, Sumifs or Sumproduct to accummulate the sales for each within a specified date range.