surfernat
IS-IT--Management
- Feb 27, 2008
- 38
Hi
I am hoping you can help this is probably very simple to do but I have no idea how to or how to google for the answer.
I have a spreadsheet as simplified below
a b c d
Date Item a/b Cost
1/11 blah a £5
2/11 blah b £1
3/11 blah a £10
4/11 blah b £2
Total A (should be £15)
Total B (should be £3)
Bascailly I want a formula to add the cost of all A's together and another one for all b's within a certain range.
Any guidance most appreciated thanks
SN
I am hoping you can help this is probably very simple to do but I have no idea how to or how to google for the answer.
I have a spreadsheet as simplified below
a b c d
Date Item a/b Cost
1/11 blah a £5
2/11 blah b £1
3/11 blah a £10
4/11 blah b £2
Total A (should be £15)
Total B (should be £3)
Bascailly I want a formula to add the cost of all A's together and another one for all b's within a certain range.
Any guidance most appreciated thanks
SN