edwardtong694
Board Regular
- Joined
- Aug 21, 2009
- Messages
- 125
Hi Guys,
Sorry for posting such a simple question, for some reason I cant seem to get this to work.
I have three rows of data.
A B C
1 Ed Apple 50p
2 Pear 25p
3 Pear 27p
4 Orange 20p
5 Dave Apple 50p
6 Pear 25p
And so on...
What I need is a formula which will calculate the total cost Ed has spent on Pears or Apples etc..
So I will have a field which says Ed Pear spend: and the formula will be something like..IF A=ED and B=Pear then Sum collumn C for those values.
Hope this makes sense.
Thanks
Ed
Sorry for posting such a simple question, for some reason I cant seem to get this to work.
I have three rows of data.
A B C
1 Ed Apple 50p
2 Pear 25p
3 Pear 27p
4 Orange 20p
5 Dave Apple 50p
6 Pear 25p
And so on...
What I need is a formula which will calculate the total cost Ed has spent on Pears or Apples etc..
So I will have a field which says Ed Pear spend: and the formula will be something like..IF A=ED and B=Pear then Sum collumn C for those values.
Hope this makes sense.
Thanks
Ed