formula to work from data column

		Microsoft Office Forums > Microsoft Excel > Excel
formula to work from data column

FAQ

Thread Tools

Display Modes

#11

08-08-2012, 07:20 AM

Colin Legg Colin Legg is offline

Windows 7 32bit formula to work from data column

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Okay, your original example had month and year numbers in separate cells. If you want to reference a single column which contains dates then a different formula is required. Here's one variation:

Code:

=AVERAGEIFS(SUPPORT!K9:K258,
    SUPPORT!J9:J258,">="&EOMONTH(TODAY(),-1)+1,
    SUPPORT!J9:J258,"<"&EOMONTH(TODAY(),0)+1)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change Resource Time vs. Duration when Updating Work column	lylel	Project	3	07-23-2012 06:09 PM
Displaying Work Week instead of date in a column.	whitney07	Project	1	07-05-2012 02:27 PM
definition of work column	ketanco	Project	9	05-31-2012 05:15 PM
Right-Aligning Data to a Column	sunnyside	Excel	3	02-27-2012 01:25 AM
Formula not getting copied to entire column	theacegary	Excel	1	11-29-2010 02:18 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:56 AM.