Adding 3 different columns based on criteria

[sparkyhp]

Hi I really hope someone can help because I'm not sure what to do for the best.

I have a master document with a summary tab and 10 or so different tabs based on our different regions.

In each of our region tabs it is filtered by "Likely" & "Very Likely" and then there are values in Columns L and Q which I need to add up, the total of these columns sit in the summary sheet for that region so it's easy for someone to go in and look at the total.

The region tabs are copied over every month with the updated changes the totals will always remain in columns L and Q is there a formula that I can put into the summary tab so that it updates every time the tabs are copied over?

Thanks (Hope some of that makes sense??)

 

[Warship]

Are you saying that you need the total of Col"L" if in the same row you have "Likely"?

And then Col"Q" if same Row has "Very Likely"?

If so what are the Col's with "Likely" & "Very Likely"?

Also what method is used to "copy over" the regional tabs ?

 

[sparkyhp]

Hi Thanks for your reply,

Likely and Very likely are both in column J then the values I would like to add could either be in L or Q.

 

[sparkyhp]

Didn't notice the last question.

I've done a VBA script which goes into the main folder filters the data by likely and very likely and then copy visible cells and then pastes it into the relevant tab on the master document.

Thanks

 

[Warship]

Not sure if I understand yet...
Is this what you need?

Excel Workbook
	J	K	L	Q
1	Check		Val "L"	Val "Q"
2	Likely		1	2
3	Very Likely		3	4
4	Very Likely		5	6
5	Likely		7	8
6	Likely		9	10
7	Very Likely		11	12
Region

Excel 2007

Excel Workbook
	S	T	U	V
1	Likely "L" total	Likely "Q" total	VeryLikely "L" total	VeryLikely "Q" total
2	17	20	19	22
Region

Excel 2007

Cell Formulas
Range	Formula
S2	=SUMIF(J2:J7,"Likely",L2:L7)
T2	=SUMIF(J2:J7,"Likely",Q2:Q7)
U2	=SUMIF(J2:J7,"Very Likely",L2:L7)
V2	=SUMIF(J2:J7,"Very Likely",Q2:Q7)

 

[sparkyhp]

Hi sorry been off work,

That looks good thanks I'll give that a go

Thanks again