Thread: formula to work from data column
View Single Post
 
Old 08-09-2012, 01:25 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default
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.
Reply With Quote