Stop Calculating at end of month

[ayseinc14]

Hello,

I have a workbook with 2 tabs. Tab 1 (Calculate) this tab has 3 different trainers with topics. #people trained and # minutes trained. Tab 2 (training Log) is the months laid out exp(C1, D1, E1, etc,, )
A1 has the names.
Now on Tab2 for each month I have the formula to grab the numbers from the cells need on Tab1. Now these are the same cells I need for the information each month. But I need the cells on Tab2 to stop calculating at end of month and start new the nest month.

---

This is example tab2 (Training Log)

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Trainers
[/TD]
[TD]Jan
[/TD]
[TD]Mar
[/TD]
[TD]Apr
[/TD]
[TD]May
[/TD]
[TD]Jun
[/TD]
[/TR]
[TR]
[TD]Jane
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Doe
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

---

Example Tab1 Calculate

[TABLE="width: 500"]
<tbody>[TR]
[TD]Jane
[/TD]
[TD]Current Month
[/TD]
[TD]Totals
[/TD]
[/TR]
[TR]
[TD]SFB
[/TD]
[TD]5
[/TD]
[TD]225
[/TD]
[/TR]
[TR]
[TD]NH
[/TD]
[TD]4
[/TD]
[TD]360
[/TD]
[/TR]
[TR]
[TD]OJT
[/TD]
[TD]3
[/TD]
[TD]45
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Doe
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SFB
[/TD]
[TD]5
[/TD]
[TD]225
[/TD]
[/TR]
[TR]
[TD]NH
[/TD]
[TD]4
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]OJT
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

In this tab I input new numbers monthly in the B column and it auto calculates by minutes in column c. So column B numbers will change every month But I need the numbers on Tab2 to stay frozen and not change when I put in the new numbers for the next month.

Any help would be greatly appreciated.

Thank you

 

[Puertorekinsam]

Based on this example, I'm not sure how you know if it's the current month or the next month....

you might want to look at the SumIf or Sumifs formula

 

[ayseinc14]

Based on this example, I'm not sure how you know if it's the current month or the next month....

you might want to look at the SumIf or Sumifs formula

Thank you for your response. Yes I am using the SUMIFS now with <> to stop the calculating. But seeing the numbers change in Tab1 every month I was just looking for something that I did not have to go into every cell and change the numbers associated to the <> on Tab2 at the end of the month to make it calculate properly.

Thank you again for your response.