Hi I am using Excel 2007 and would like to total a column dependant on the value selected in another column
For instance if Column A has various text values and column B has numeric values
I want to show a total at the bottom of column B dependant on a certain value in column A
Say I had two values in Col A, ie "Yesterday" and "Tomorrow" I only want Col B values opposite Yesterday to be in the total

Any suggestions would be helpful