formula to work from data column

Colin Legg · #16 08-09-2012, 01:25 AM

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.

masterdineen · #17 08-09-2012, 07:52 AM

Thank you very much.

It’s always something simple.

I’m getting there now.

I am creating a temporary Support Reporting dashboard

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