If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
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. . |
#7
|
|||
|
|||
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. . |
Thread Tools | |
Display Modes | |
|
|