INDIRECT COUNTIF's??

[alymcmorland]

Can you mix this statement:


VBA:

=COUNTIF( '2005'!B6:B370,"L")

of which counts all the L's that appear from B6 to B370 on tab shee
2005 with this one:


VBA:

=INDIRECT("'"&YEAR(NOW())&"'!B1")

of which finds out what year it is and then points itself to th
correct tab sheet, baring in mind that the tab sheets are named afte
the years so like 2005 2006 2007 etc..

Anyway what i want is like an indirect countif statement, i need th
function of the countif statement but where it says '2005' i need tha
number to be determined by what the year currently is, of which i
where the functionality of the indirect statement comes in, s
depending on what year it is depends on the tab sheet but it needs t
countif still.

Is this possible

 

[Bob Phillips]

=COUNTIF(INDIRECT("'"&YEAR(TODAY())&"'!B6:B370"),"L")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"alymcmorland" <[email protected]>
wrote in message
news:[email protected]...