| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Newbie Questions
YOU ARE THE GREATEST!!! Thank you!!!!
"Luke M" wrote: It's unclear, but I think you've been asked to generate some SUMIF formulas. Rewritten, you're wanting to look at Sheet A, and in a certain column, find all dates matching your criteria from Sheet B, and then sum the associated dollar value with those dates? Assuming on Sheet A column A contains dates, and column B contains the dollars, and on sheet B first date you want info on is in A2, place this into B2 of sheet B: =SUMIF('Sheet A'!$A:$A,A2,'Sheet A'!$B:$B) Copy formula down as needed. If this situation is NOT your situation, perhaps you could try to explain again what you want, or post examples of what you have, and what you would like to see? -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "KS" wrote: Hey all, I need some help... got thrown into a project that I dont know much about. I need to compare one date column in worksheed A to another date column in worksheet B and pull in a dollar value from worksheet A to an empty column in worksheet B. Also, the dollar value needs to be sumed (by date) before it gets to the new column. I hope that makes sense...Please!!! someone help me. I am not an excel person, I write SQL. THANKS in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Newbie Questions ? | New Users to Excel | |||
| Real Newbie newbie question | New Users to Excel | |||
| Newbie Questions - X Axis and Data Range | Charts and Charting in Excel | |||
| Newbie questions on spreadsheet | Excel Worksheet Functions | |||
| newbie questions | Excel Worksheet Functions | |||
Hybrid Mode
