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 |