formula to work from data column

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

#16

08-09-2012, 01:25 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

Hi Rob,

That's because you've got the sizes of the ranges slightly skewed:

Code:

=COUNTIFS(SUPPORT!H8:H25,"Martin",SUPPORT!M9:M25,YEAR(TODAY()))

I guess you want it to start from row 9, so:

Code:

=COUNTIFS(SUPPORT!H9:H25,"Martin",SUPPORT!M9:M25,YEAR(TODAY()))

Also, I noticed that in the other formula you went down to row 250 (not row 25), so you might need to change that too.

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 05:47 PM.