IF, AND Statement, Formula Help

[sccson]

I have this Formula:

=IF(AND(Sheet1!A48="Steve Jones",Sheet1!A47<=11/31/2005),Sheet1!B48,"It Works")

I want it to add a value to each Month's Column. Example:

Nov Dec Jan

12 22 16

The value comes from "Sheet1!B48". I'm able to get the value in the column, but I want it to add it to the appropriate month column, WITHOUT changing the previous month.

So I placed the <, >, in front of the Month, but can't seem to get it to change as the month's change.

 

[NBVC]

Not totally sure what you want to do,

but if you replace the month part with Today(), does that work?

If not, you will need to elaborate on what you are trying to achieve, perhaps post samples of where the data is coming from and what you want to get as results and where.