Dumb Newbie question...
While I am decently versed in things like Perl, I pretty much know next to nothing about formulas in spreadsheets 🙂 So I am hoping for some help.
I have a Spreadsheet with 2 columns, the first is a Date Column (Column A) that looks like
Wed, Jan 16, 2008
Thu, Jan 17, 2008
...
Wed, Oct 14, 2009
Thu, Oct 15, 2009
The second column (Column E) is just simply numbers like
1
11
...
34
12
What I need to do is select each and every <name of day> (Column A) for a given year and the corresponding value in Column E, then sum the values of Column E into a new cell so I would end up with something like
MondayTuesday Wednesday Thursday Friday Saturday Sunday
2008 2345 3123 1125
2009 341 2241 9871
Can anyone direct me how to do this? I tried to look around at other posts here and saw a =SUMIF(DATA :: $A,"="&A1,DATA :: $B) or something similar, but that doesn't do what I need so I tried to modify it using a VLOOKUP() in place of the &A1 thinking maybe I could select each day in Column A using wildcards, but that didn't seem to work either...Since I know so little about how these spreadsheet calcs work, I figured it would be better to ask for help and a detailed explanation if possible, than to try to go it alone anymore 🙂
Thanks in Advance for any help you can give 🙂
I have a Spreadsheet with 2 columns, the first is a Date Column (Column A) that looks like
Wed, Jan 16, 2008
Thu, Jan 17, 2008
...
Wed, Oct 14, 2009
Thu, Oct 15, 2009
The second column (Column E) is just simply numbers like
1
11
...
34
12
What I need to do is select each and every <name of day> (Column A) for a given year and the corresponding value in Column E, then sum the values of Column E into a new cell so I would end up with something like
MondayTuesday Wednesday Thursday Friday Saturday Sunday
2008 2345 3123 1125
2009 341 2241 9871
Can anyone direct me how to do this? I tried to look around at other posts here and saw a =SUMIF(DATA :: $A,"="&A1,DATA :: $B) or something similar, but that doesn't do what I need so I tried to modify it using a VLOOKUP() in place of the &A1 thinking maybe I could select each day in Column A using wildcards, but that didn't seem to work either...Since I know so little about how these spreadsheet calcs work, I figured it would be better to ask for help and a detailed explanation if possible, than to try to go it alone anymore 🙂
Thanks in Advance for any help you can give 🙂
G4 Mac Mini, Mac OS X (10.6.1), perl, MacOS X, Lineage :) :) :)