I have a problem with an Excel spreadsheet.
What i am trying to do is this:
I have a set of Columns with the names PAPER, VALUE,PRICE,DAYS,SOLD.
Under the PAPER column i have inserted names-Sun,Record,Herald,Post,etc.
I have another column NamedVALUE
Each PAPER has a VALUE assigned to it say Sun=1,Record=2 etc.
There is a third column COST. This has a paper value in ?
The fourth column i have is DAYS for the day of the week.
The fifth column i have is the SOLD column.
I have applied afilter to my data in order that i can have only the Heralds fields showing for example.
This shows me how many heralds i sold on a certain day and at what price etc. (as the price of newspapers may sometimes not always be constant).
What i want toknow is this:
When i filter data is there anyway to have the results of the filtered data sorted in order that it can work the cost out for me?
How would i achieve this? Could i do something similar to. Sum=all row A*all row B —And would this work on filtered colums?
Any suggestions at all much appreciated. Thanks in advance!