Still doing my best to learn Excel.
I have a spreadsheet set up as follows:
Month Day Genre Sales
Jan Sat Concert 1,500
Feb Fri Play 700
Feb Fri Lecture 200
Feb Mon Musical 400
Mar Fri Other 300
In another sheet, I have a table with the following:
Month Day Genre TotalSales
(List) (List) (List)
In the TotalSales cell, I would like to sum the total amount of sales based on the criteria I choose from the lists. For instance, if I choose Jan for the month, I want TotalSales to report 1,500. If I choose Fri for Day, I want it to report 1,000.
But I also want to be able to choose Feb for Month, AND Fri for Day, leave the Genre list empty, and have TotalSales report 900. I can't seem to do this while leaving the Genre list cell empty. If I choose Play for Genre, it gives me 700. But leaving it blank gives me 0.
My current Function:
=SUMIFS('Events'!D:D,'Events'!A:A,A2,'Events'!B:B,B2,'Events'!C:C,C2)
Am I correct in using the SUMIFS function, and do I just need to add something to it? Or is there another way to do this?
Bookmarks