june

I have 38 sections identical to this (Below) and I am trying to collect all the m's for a particular month in this case November the 1st. Is this possible as Countif(s), Sumif(s), sumproduct, index and match do not work please advise? <colgroup><col><col span="26"><col><col...

Hi Guys! I am new to this forum and no great shakes at Excel, but I have a problem that I hope that you can help me with. My actual data is more sophisticated, but I have simplified it here for the purposes of clarity. I have a simple two column spread sheet. Column 1 shows the Names, Columns 2...

I'm stuck with a request from my boss that wants a line graph for some Documents used for training. Right now I have the documents sitting in Folders Named Approved, Draft for Review, and Ready for Review I'm wondering how to effectively display the data that will show progress. Currently, I...

Thanks in advance for any help or advice. I'm not sure how to include an Excel fragment in the post so I'll do it the old fashioned way. I have 4 columns. In column A are calendar dates. In column B are values of either 0, 1 or 2. These values are manually inserted by the user. What I...

Hello, Pretty basic one, but I can't seem to figure it out. I'm pretty ignorant to sheets formulas. I need to split the deal revenue across each month based on the start date and end date of a campaign. As an example, A2 needs to be split for the last 3 days of May, the first 8 days of...