txoxmxaxsx
New Member
- Joined
- Jul 27, 2010
- Messages
- 14
Hi,
Im working with an excel book that has 13 worksheets. One of the worksheets has a summary of all our POs and the other 12 are the months.
On the summary sheet I have a colum labeled "Surplus". Every month we bill the customers an x amount(may vary from month to month). What I need is to add the billed amount from each month and take it from the PO total.
The trick is that not all the POs go through the entire year so I may get the #N/A and my vlookup wont be of any use.
Thanks in advance
Im working with an excel book that has 13 worksheets. One of the worksheets has a summary of all our POs and the other 12 are the months.
On the summary sheet I have a colum labeled "Surplus". Every month we bill the customers an x amount(may vary from month to month). What I need is to add the billed amount from each month and take it from the PO total.
The trick is that not all the POs go through the entire year so I may get the #N/A and my vlookup wont be of any use.
Thanks in advance