DPChristman
Board Regular
- Joined
- Sep 4, 2012
- Messages
- 176
- Office Version
- 365
- Platform
- Windows
So, here is my conundrum...
I am trying to summarize data by month, based on a couple of variables.
Example:
If the Value in a column is YES, and a value in another column is a specific month, then summarize the total dollars in a third column.
Now, if I was only looking for the count of items, I could do this easily with a countifs function.
However, I am looking the dollars in a third column.
I know I can do this sloppily, by creating a (hidden) column that would say something like =F5&BN5 to achieve a result of FEBYES in column BP, then do a =sumif BP:BP=FEBYES,AM:AM, but this seems ridiculously complicated, and by time I am done, I will have a bunch of extra columns added to spreadsheet.
There has to be a simpler way to accomplish this.
Any Thoughts?
Thanks,
Dan
BTW we are talking office 2010
I am trying to summarize data by month, based on a couple of variables.
Example:
If the Value in a column is YES, and a value in another column is a specific month, then summarize the total dollars in a third column.
Now, if I was only looking for the count of items, I could do this easily with a countifs function.
However, I am looking the dollars in a third column.
I know I can do this sloppily, by creating a (hidden) column that would say something like =F5&BN5 to achieve a result of FEBYES in column BP, then do a =sumif BP:BP=FEBYES,AM:AM, but this seems ridiculously complicated, and by time I am done, I will have a bunch of extra columns added to spreadsheet.
There has to be a simpler way to accomplish this.
Any Thoughts?
Thanks,
Dan
BTW we are talking office 2010