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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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