Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtracting sumed figures from the YR before
I have this whole spreadsheet which i had to subtracted sum of YEAR 2 figures
from sum of YEAR 1 in the corresponding period. For example: Pdt 1 Result = (Year 2 M3+M2)-(Year 1 M3+M2) Pdt 2 Result = (Year 2 M3)-(Year 1 M3) YEAR 2 YEAR 1 M3 M2 M1 M3 M2 M1 PDT 1 200 200 400 400 400 PDT 2 400 500 500 500 PDT 3 100 100 100 200 PDT 4 500 500 200 200 200 PDT 5 100 100 100 100 Is there anyway i can do this effectively? -- sarah |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtracting sumed figures from the YR before
Assuming PDT1 is in B2:D2, PDT2 is in F2:H2. Then, in J2 you can put
your figure for PDT1: =SUMPRODUCT((B2:D2<"")*(F2:H2<"")*(B2:D2-F2:H2)) HTH Kostis Vezerides sarah wrote: I have this whole spreadsheet which i had to subtracted sum of YEAR 2 figures from sum of YEAR 1 in the corresponding period. For example: Pdt 1 Result = (Year 2 M3+M2)-(Year 1 M3+M2) Pdt 2 Result = (Year 2 M3)-(Year 1 M3) YEAR 2 YEAR 1 M3 M2 M1 M3 M2 M1 PDT 1 200 200 400 400 400 PDT 2 400 500 500 500 PDT 3 100 100 100 200 PDT 4 500 500 200 200 200 PDT 5 100 100 100 100 Is there anyway i can do this effectively? -- sarah |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtracting | Excel Worksheet Functions | |||
Subtracting | Excel Worksheet Functions | |||
Subtracting | Charts and Charting in Excel | |||
add figures to existing figures in excel | Excel Worksheet Functions | |||
Changing positive figures to minus figures | Excel Worksheet Functions |