Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Question
I have a worksheet of events or items called Events.
Column A is Date Column C is Cost Other columns are irrelevant (names, contacts, address, etc) I have another summary sheet that calculates and summaizes how much cost per day. Column A is the Date from 1/1/06 - 1/31/06 If I use the following formula: =SUMIF(Events!$A:$A,"A2", Events!$C:$C) The formula gives me an answer = 0 If I use the following formula: =SUMIF(Events!$A:$A,"1/1/06", Events!$C:$C) The formula gives me an answer = $1,250.00 What I would like to do is that everytime I change the date in Column A of the summary sheet, that it will change the formulas also. Any help is appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Question
Hi
Try this: =SUMIF(Events!$A:$A,""&A2, Events!$C:$C) Andy. "Brig Siton" wrote in message ... I have a worksheet of events or items called Events. Column A is Date Column C is Cost Other columns are irrelevant (names, contacts, address, etc) I have another summary sheet that calculates and summaizes how much cost per day. Column A is the Date from 1/1/06 - 1/31/06 If I use the following formula: =SUMIF(Events!$A:$A,"A2", Events!$C:$C) The formula gives me an answer = 0 If I use the following formula: =SUMIF(Events!$A:$A,"1/1/06", Events!$C:$C) The formula gives me an answer = $1,250.00 What I would like to do is that everytime I change the date in Column A of the summary sheet, that it will change the formulas also. Any help is appreciated. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Question
That's it.
My forehead is still red for hitting it when the formula worked. Thank you very much. <Andy wrote in message ... Hi Try this: =SUMIF(Events!$A:$A,""&A2, Events!$C:$C) Andy. "Brig Siton" wrote in message ... I have a worksheet of events or items called Events. Column A is Date Column C is Cost Other columns are irrelevant (names, contacts, address, etc) I have another summary sheet that calculates and summaizes how much cost per day. Column A is the Date from 1/1/06 - 1/31/06 If I use the following formula: =SUMIF(Events!$A:$A,"A2", Events!$C:$C) The formula gives me an answer = 0 If I use the following formula: =SUMIF(Events!$A:$A,"1/1/06", Events!$C:$C) The formula gives me an answer = $1,250.00 What I would like to do is that everytime I change the date in Column A of the summary sheet, that it will change the formulas also. Any help is appreciated. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Question
It's OK! Thanks for the feedback!
Andy. "Brig Siton" wrote in message ... That's it. My forehead is still red for hitting it when the formula worked. Thank you very much. <Andy wrote in message ... Hi Try this: =SUMIF(Events!$A:$A,""&A2, Events!$C:$C) Andy. "Brig Siton" wrote in message ... I have a worksheet of events or items called Events. Column A is Date Column C is Cost Other columns are irrelevant (names, contacts, address, etc) I have another summary sheet that calculates and summaizes how much cost per day. Column A is the Date from 1/1/06 - 1/31/06 If I use the following formula: =SUMIF(Events!$A:$A,"A2", Events!$C:$C) The formula gives me an answer = 0 If I use the following formula: =SUMIF(Events!$A:$A,"1/1/06", Events!$C:$C) The formula gives me an answer = $1,250.00 What I would like to do is that everytime I change the date in Column A of the summary sheet, that it will change the formulas also. Any help is appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif question | Excel Worksheet Functions | |||
Complicated SUMPRODUCT OR SUMIF question? | Excel Discussion (Misc queries) | |||
SUMIF function question | Excel Worksheet Functions | |||
this may be simple, sumif question | Excel Worksheet Functions | |||
SUMIF question | Excel Worksheet Functions |