| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Want to access the SUBTOTAL of a list from within a worksheet
I think that this is an easy question but I simply couldn't find the answer.
I have the following list in XL2003 Column1 Column 2 PAYMENTS 100 CREDIT 200 PAYMENTS 1000 I want to create a formula somewhere in Sheet1 that will produce me the equivalent of the sum of Column 2 where Column1=PAYMENTS. In other wants the SUM of PAYMENTS is 1100. How can I access this sum using a formula somewhere in my worksheet. Thanks Michael |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Want to access the SUBTOTAL of a list from within a worksheet
With your posted data in columns A and B...
AND C1: PAYMENTS Then this formula returns the sum of Col_B amounts corresponding to PAYMENTS: D1: =SUMIF(A1:B5,C1,B1:B5) Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Michael" wrote in message ... I think that this is an easy question but I simply couldn't find the answer. I have the following list in XL2003 Column1 Column 2 PAYMENTS 100 CREDIT 200 PAYMENTS 1000 I want to create a formula somewhere in Sheet1 that will produce me the equivalent of the sum of Column 2 where Column1=PAYMENTS. In other wants the SUM of PAYMENTS is 1100. How can I access this sum using a formula somewhere in my worksheet. Thanks Michael |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Want to access the SUBTOTAL of a list from within a worksheet
Thanks Ron,
This worked great ! - Michael "Ron Coderre" wrote in message ... With your posted data in columns A and B... AND C1: PAYMENTS Then this formula returns the sum of Col_B amounts corresponding to PAYMENTS: D1: =SUMIF(A1:B5,C1,B1:B5) Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Michael" wrote in message ... I think that this is an easy question but I simply couldn't find the answer. I have the following list in XL2003 Column1 Column 2 PAYMENTS 100 CREDIT 200 PAYMENTS 1000 I want to create a formula somewhere in Sheet1 that will produce me the equivalent of the sum of Column 2 where Column1=PAYMENTS. In other wants the SUM of PAYMENTS is 1100. How can I access this sum using a formula somewhere in my worksheet. Thanks Michael |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Want to access the SUBTOTAL of a list from within a worksheet
You're welcome....I'm glad I could help.
-------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Michael" wrote in message ... Thanks Ron, This worked great ! - Michael "Ron Coderre" wrote in message ... With your posted data in columns A and B... AND C1: PAYMENTS Then this formula returns the sum of Col_B amounts corresponding to PAYMENTS: D1: =SUMIF(A1:B5,C1,B1:B5) Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Michael" wrote in message ... I think that this is an easy question but I simply couldn't find the answer. I have the following list in XL2003 Column1 Column 2 PAYMENTS 100 CREDIT 200 PAYMENTS 1000 I want to create a formula somewhere in Sheet1 that will produce me the equivalent of the sum of Column 2 where Column1=PAYMENTS. In other wants the SUM of PAYMENTS is 1100. How can I access this sum using a formula somewhere in my worksheet. Thanks Michael |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUBTOTAL A LIST | Excel Discussion (Misc queries) | |||
| List and subtotal selected items, then print separate item list | Excel Worksheet Functions | |||
| subtotal a list on each of several pages | Excel Discussion (Misc queries) | |||
| subtotal in a list | Excel Discussion (Misc queries) | |||
| {SUBTOTAL(2, IF(This = That, LIST))} | Excel Worksheet Functions | |||
![Michael[_44_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
