formula to work from data column

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

FAQ

Mark Forums Read

Thread Tools

Display Modes

08-08-2012, 04:21 AM

masterdineen masterdineen is offline

Windows XP formula to work from data column

Office 2010 32bit

Novice

Join Date: Aug 2012

Posts: 11

formula to work from data column

Hello

I have the following equation =AVERAGEIF(SUPPORT!K9:K99, ">0")

support!K9:K99 being number of daydiff.

I want to select the daydiff values based on another date column, that only has the current month and year. ie Aug(8) & 2012

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 11:15 PM.