| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumif function problem
Hi All,
Could somebody can provide with a formula to sum Column B data for all the data that start with "009" in column A Ex - The formula should give me 100 as answer. Column A Column B 00911 60 00111 30 00112 20 00922 40 Thanks in Advance. Thyag |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sumif function problem
=SUMPRODUCT((LEFT(A5:A8,3)="009")*B5:B8) "Thyag" wrote: Hi All, Could somebody can provide with a formula to sum Column B data for all the data that start with "009" in column A Ex - The formula should give me 100 as answer. Column A Column B 00911 60 00111 30 00112 20 00922 40 Thanks in Advance. Thyag |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sumif function problem
=SUMIF(A:A,"009*",B:B)
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Thyag" wrote in message ... Hi All, Could somebody can provide with a formula to sum Column B data for all the data that start with "009" in column A Ex - The formula should give me 100 as answer. Column A Column B 00911 60 00111 30 00112 20 00922 40 Thanks in Advance. Thyag |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sumif function problem
On Dec 21, 9:40*am, Thyag wrote:
Hi All, Could somebody can provide with a formula to sum Column B data for all the data that start with "009" in column A Ex - The formula should give me 100 as answer. Column A * * * *Column B 00911 * 60 00111 * 30 00112 * 20 00922 * 40 Thanks in Advance. Thyag Thanks Joel and Bob. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF function problem | Excel Worksheet Functions | |||
| Excel SUMIF function problem | Excel Worksheet Functions | |||
| SUMIF Function Problem | Excel Discussion (Misc queries) | |||
| Problem in SUMIF Function | Excel Discussion (Misc queries) | |||
| VBA €“ Problem with compound SUMIF function | Excel Programming | |||
Hybrid Mode
