Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add and subract in one sum
I have a worksheet that has balances for delivery and usage. they are all on
one line and a want a monthly use at the end. so 10 delivered mon 1 used tues 1 wed 3 del thurs 1 used friday. Each day being a different column. how would my sum look please? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add and subract in one sum
why not put 10 to start and then use -1 -3
then =sum( -- Don Guillett SalesAid Software "k1ngy" wrote in message ... I have a worksheet that has balances for delivery and usage. they are all on one line and a want a monthly use at the end. so 10 delivered mon 1 used tues 1 wed 3 del thurs 1 used friday. Each day being a different column. how would my sum look please? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add and subract in one sum
Can you post an example of the data. I think you should be able to use a sumif statement if you want to sum all the delivery's on a Mon for example. e.g =SUMIF(A:A,"Mon",B:B) -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=552962 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add and subract in one sum
Just enter negative numbers in the columns when they are used.
Say that: A2 Mon = 10 B2 Tues = -1 C2 Wed = -1 D2 Thurs = 3 E2 Fri = -1 F2 etc... And your formula is: =SUM(A2:AE2) For the entire month. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "k1ngy" wrote in message ... I have a worksheet that has balances for delivery and usage. they are all on one line and a want a monthly use at the end. so 10 delivered mon 1 used tues 1 wed 3 del thurs 1 used friday. Each day being a different column. how would my sum look please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|