M
Mantis2k
Good Morning
I was wondering if anyone could give me advice on a formula for picking out
information in a running spreadsheet. I need to get information from a set
month (i.e. october), a specific product and the value of this.
Below is an example of what im working with...
A=Date
B=Product
C=Value
A B C
1 23/10/2007 QB £1000
2 14/11/2007 QB £2300
3 02/10/2007 QB £500.50
4 24/09/2007 S&L £1300
5 15/10/2007 QL £3420
6 18/11/2007 QB £2000
As mentioned above im trying to make a formula which will pick out
information in october for a product called 'QB' and give me a total sum (in
this case £1500.50).
I would greatly appreciate anyones help!
Thank You!
I was wondering if anyone could give me advice on a formula for picking out
information in a running spreadsheet. I need to get information from a set
month (i.e. october), a specific product and the value of this.
Below is an example of what im working with...
A=Date
B=Product
C=Value
A B C
1 23/10/2007 QB £1000
2 14/11/2007 QB £2300
3 02/10/2007 QB £500.50
4 24/09/2007 S&L £1300
5 15/10/2007 QL £3420
6 18/11/2007 QB £2000
As mentioned above im trying to make a formula which will pick out
information in october for a product called 'QB' and give me a total sum (in
this case £1500.50).
I would greatly appreciate anyones help!
Thank You!