zahidislam14
New Member
- Joined
- Jun 5, 2018
- Messages
- 3
Hello All,
I am trying to build a order tracking excel sheet where I can input the order/s from a specific client and it will spit out the total and keep a monthly tracker of how much was ordered and by whom?
I have attached the file and would like to ask if you can help with the following:
1) I have gotten rid of the N/A (s) by using the IF(ISNA...) but how can I get rid of #value! and also have column P (Total payments) calculate the total?
2) If "Cus 1" has more rows, how can I calculate a subtotal from all the rows? Also if that customer wants to order again, how can we keep it separate (may be do a check of when they ordered i.e date)?
3) how can we take the data on "Order" sheet and build a monthly report or yearly?
I know this is a lot to ask but some direction or help would help me learn
Thank you in advance!
I am trying to build a order tracking excel sheet where I can input the order/s from a specific client and it will spit out the total and keep a monthly tracker of how much was ordered and by whom?
I have attached the file and would like to ask if you can help with the following:
1) I have gotten rid of the N/A (s) by using the IF(ISNA...) but how can I get rid of #value! and also have column P (Total payments) calculate the total?
2) If "Cus 1" has more rows, how can I calculate a subtotal from all the rows? Also if that customer wants to order again, how can we keep it separate (may be do a check of when they ordered i.e date)?
3) how can we take the data on "Order" sheet and build a monthly report or yearly?
I know this is a lot to ask but some direction or help would help me learn