Cell reference for year in formula

  • Thread starter Thread starter Cush
  • Start date Start date
C

Cush

The following formula works fine, but I want the year for the date within the
quotes to come from a cell reference. Does anyone know how I need to alter
the formula to make this happen? I've tried to replace the 09 with a cell
reference but have had no luck.

=SUMIFS('Check Register'!H2:H1000,'Check
Register'!B2:B1000,">3/31/09",'Check Register'!B2:B1000,"<4/15/09",'Check
Register'!D2:D1000,A43)
 
">3/31/09"

becomes

">3/31/"& A1

where A1 contains 09, so it has to be text, not a number. You can achieve
that by formatting the cell as text before you enter 09
If the year is the result of a calculation, (so it is the number 9) and is
in B1, then in A1 enter:

=TEXT(B1,"00")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Quarterly Formula 1
#Value! Same formula, different outcomes 5
How to replace single cell references with row names? 2
Need to reference two cells to construct formula 1
Reference a row programmatically 1
Auto update/fill column heading 4
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
macro on different reports CTRL+F in formula 2

Back
Top