| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Comparing, Matching, and Sum formula
Hello.
Column A has dates. The format is 2010-04-29. There are multiple rows with the same date. Column B has numbers Please, provide me the formula IF: column A="2010-04-29" then SUM(B:B) Thank you. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Comparing, Matching, and Sum formula
=IF(A1=DATE(2010,4,29),SUM(B:B),0)
-- Regards Dave Hawley www.ozgrid.com "ma" wrote in message ... Hello. Column A has dates. The format is 2010-04-29. There are multiple rows with the same date. Column B has numbers Please, provide me the formula IF: column A="2010-04-29" then SUM(B:B) Thank you. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Comparing, Matching, and Sum formula
Thank you for your response.
How would I modify it so that it only summed column B so as long as Date= 2010,4,29 in any row of column A. Right now it's summing all of column B even when the date changes. "ozgrid.com" wrote: =IF(A1=DATE(2010,4,29),SUM(B:B),0) -- Regards Dave Hawley www.ozgrid.com "ma" wrote in message ... Hello. Column A has dates. The format is 2010-04-29. There are multiple rows with the same date. Column B has numbers Please, provide me the formula IF: column A="2010-04-29" then SUM(B:B) Thank you. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Comparing, Matching, and Sum formula
Try this...
=SUMIF(A:A,DATE(2010,4,29),B:B) Better to use a cell to hold the date D1 = 4/29/2010 =SUMIF(A:A,D1,B:B) -- Biff Microsoft Excel MVP "ma" wrote in message ... Thank you for your response. How would I modify it so that it only summed column B so as long as Date= 2010,4,29 in any row of column A. Right now it's summing all of column B even when the date changes. "ozgrid.com" wrote: =IF(A1=DATE(2010,4,29),SUM(B:B),0) -- Regards Dave Hawley www.ozgrid.com "ma" wrote in message ... Hello. Column A has dates. The format is 2010-04-29. There are multiple rows with the same date. Column B has numbers Please, provide me the formula IF: column A="2010-04-29" then SUM(B:B) Thank you. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Comparing, Matching, and Sum formula
Thank you. I went with the second formula and it worked!
"T. Valko" wrote: Try this... =SUMIF(A:A,DATE(2010,4,29),B:B) Better to use a cell to hold the date D1 = 4/29/2010 =SUMIF(A:A,D1,B:B) -- Biff Microsoft Excel MVP "ma" wrote in message ... Thank you for your response. How would I modify it so that it only summed column B so as long as Date= 2010,4,29 in any row of column A. Right now it's summing all of column B even when the date changes. "ozgrid.com" wrote: =IF(A1=DATE(2010,4,29),SUM(B:B),0) -- Regards Dave Hawley www.ozgrid.com "ma" wrote in message ... Hello. Column A has dates. The format is 2010-04-29. There are multiple rows with the same date. Column B has numbers Please, provide me the formula IF: column A="2010-04-29" then SUM(B:B) Thank you. . |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Comparing, Matching, and Sum formula
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "ma" wrote in message ... Thank you. I went with the second formula and it worked! "T. Valko" wrote: Try this... =SUMIF(A:A,DATE(2010,4,29),B:B) Better to use a cell to hold the date D1 = 4/29/2010 =SUMIF(A:A,D1,B:B) -- Biff Microsoft Excel MVP "ma" wrote in message ... Thank you for your response. How would I modify it so that it only summed column B so as long as Date= 2010,4,29 in any row of column A. Right now it's summing all of column B even when the date changes. "ozgrid.com" wrote: =IF(A1=DATE(2010,4,29),SUM(B:B),0) -- Regards Dave Hawley www.ozgrid.com "ma" wrote in message ... Hello. Column A has dates. The format is 2010-04-29. There are multiple rows with the same date. Column B has numbers Please, provide me the formula IF: column A="2010-04-29" then SUM(B:B) Thank you. . |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Comparing, Matching, and Sum formula
I appreciate your response.
Could you tell me how I would modify this so that it only sums what is B so as long as the DATE is 2010,4,29 in column A? Currently, it is summing the whole column even when the date changes. Example: 2010-04-29 2 2010-04-29 7 2010-04-29 1 2010-04-28 4 2010-04-28 3 Results: 10 7 "ozgrid.com" wrote: =IF(A1=DATE(2010,4,29),SUM(B:B),0) -- Regards Dave Hawley www.ozgrid.com "ma" wrote in message ... Hello. Column A has dates. The format is 2010-04-29. There are multiple rows with the same date. Column B has numbers Please, provide me the formula IF: column A="2010-04-29" then SUM(B:B) Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column Matching/Comparing | Excel Discussion (Misc queries) | |||
| Comparing/Matching two columns | Excel Worksheet Functions | |||
| Comparing & Stating The Nearest Matching | Excel Discussion (Misc queries) | |||
| matching/comparing lists | Excel Worksheet Functions | |||
| Comparing two columns and finding matching names | Excel Worksheet Functions | |||
Hybrid Mode
