AbelGoodwin1988
New Member
- Joined
- Jun 18, 2012
- Messages
- 20
Hello!,
I have two questions.
Excel 2007
<tbody>
</tbody>
One:
What i'm trying to do here is in the column # of purchases help me return the number of times that I have purchased a good.
For example if I made a purchase on 4/4/2012 but not on 4/16/2012 it would be 1. If it was purchased both dates then it would be two.
I'm assuming i'll use something along the lines of COUNTIF. I'm trying to do something like, COUNTIF(C3:AA3,?)/3.
So that question number one.
Two:
I want to, in the units column, have it divide the cost by price/unit to determine the # of units or lbs of something we bought. On some of the cost and price/unit sections though, there is nothing; which returns a div/0 error. I'm assuming i can use an IF formula somehow to say if in these two cells there is a number then divide, if not "".
So, any pointers would be much appreciated!
Man Excel is so fun!
Thank you, again!
I have two questions.
Excel 2007
B | C | D | E | F | G | H | I | |
---|---|---|---|---|---|---|---|---|
1 | # of Purchases | Food | Cost | Price/Unit | Units | Cost | Price/Unit | Units |
2 | 4/4/2012 | 4/16/2012 | ||||||
3 | Apples, Gala # | 2.55 | 0.78 | 5.56 | 0.78 |
<tbody>
</tbody>
Grocery Mastersheet
My wife and I are learning to use some excel and we decided a fun practice might be compiling data with grocery shopping.One:
What i'm trying to do here is in the column # of purchases help me return the number of times that I have purchased a good.
For example if I made a purchase on 4/4/2012 but not on 4/16/2012 it would be 1. If it was purchased both dates then it would be two.
I'm assuming i'll use something along the lines of COUNTIF. I'm trying to do something like, COUNTIF(C3:AA3,?)/3.
So that question number one.
Two:
I want to, in the units column, have it divide the cost by price/unit to determine the # of units or lbs of something we bought. On some of the cost and price/unit sections though, there is nothing; which returns a div/0 error. I'm assuming i can use an IF formula somehow to say if in these two cells there is a number then divide, if not "".
So, any pointers would be much appreciated!
Man Excel is so fun!
Thank you, again!