Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Blank Cells Again
Thanks for everyone's help, here is the problem I am trying to solve
I have two sheets within a workbook; On sheet one I have three columns; Column A has a list of dates, Column B has a list of dollar amounts and Column C has random words It looks somewhat like this Column A Column B Column C 10/24/2008 $100 Dog 10/23/2008 $220 Cat 10/20/2008 $100 10/19/2008 $115 Dog 10/19/2008 $230 10/18/2008 $115 Mouse 10/16/2008 $300 On the second sheet I have a list of dates and I want to find out the total revenue from column B on the first sheet between two dates, say 10/19/2008 and 10/23/2008 and that have words written in column C. I then want to do the same thing with things that don't have words written in Column C. Any help would be greatly appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
Quantity Blank, Remaining cells in row appear Blank | Excel Worksheet Functions | |||
Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions | |||
Making Blank Cells Really Blank (Zen Koan) | Excel Worksheet Functions |