march

Hi I'd like to create a sumif formula that sums up data based on criteria in multiple columns, but not sure if this is possible? In the table below, I'd like to sum up the number of HOURS for Greg (a user) that are i) approved (column G) ii) billable (column H) iii) from the month of August...

Hi, I am setting up a Balanced Scorecard in Excel 2016 and wondered if I could automate the process as I have a lot of data to go through. I was thinking if doing this by conditional formatting but do not know if this is possible? I want to put the Balanced Scorecard in Sheet1 and in Sheet2...

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...

Hello All My question this afternoon, Is there an alternate way to average December January & February The formula I am using is ={SUM(SUMIFS($B$5:$B$16,$A$5:$A$16,{"December","January","February"}))/SUM(COUNTIFS($A$5:$A$16,{"December","January","February"}))} <tbody> January 25...

Hello All, Pardon if my question is already posted. I have a daily time series of flow volumes at 37 sites ( 37 columns) between 2004 to 2016. I need a monthly sum between summer months (September to March) throughout entire period. For example, a monthly total from September 2004 to March...