formula to work from data column

masterdineen · #1 08-08-2012, 08:13 AM

its ok, ive worked it out.

thank you again for you help.

Regards

Rob

masterdineen · #2 08-08-2012, 02:35 PM

now i am trying the following formula

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

and i get #Value!

but when i create the same formula on the support sheet.

ie =COUNTIFS(H9:H250,"Martin",M9:M250,YEAR(TODAY())) and it works.

Is there limits when referencing other sheets in workbook?

Colin Legg · #3 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 · #4 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