Retuen sum across multiple vlookups

[sunirms]

Excel 2007
ABCDEFGH33Tower1Name of AccountAlert CountSev1Sev2Sev3Sev4
34
CPW4
2



=SUM(VLOOKUP("CPW",B34:G34,2,FALSE),VLOOKUP("CPW",B35:G35,2,FALSE))
35
YARA3
3



36Tower2CPW2
2



37
YARA3





38Tower3CPW2





39
YARA





40Tower4JLR Washington4





41
CPW





42Tower5JLR Washington





43
CPW





44Tower6JLR Washington





45
CPW





46Tower7JLR  SWIFT





47
ATKINS





48Tower8DANONE





49
YARA





50Tower9DANONE





51
YARA





[CENTER][COLOR=#161120][B]1-Sep-2011[/B][/COLOR][/CENTER]


Worksheet FormulasCellFormulaH34=SUM(VLOOKUP("CPW",B34:G34,2,FALSE),VLOOKUP("CPW",B35:G35,2,FALSE))

Hi All

I am loooking for a way to get the sum of Alert count cells for "CPW" alone. the total sum. The formula i used serves the purpose, but i have to manually enter vlookups for each row and excel does not allow me to add to many arguments. Is there any alternate way of doing this? The only way out would be to return vlookups row wise and then take a total count. Is there a way to get it in one single cell rather than performing vlookups row wise and then takint the sum of it??

 

[Robert Mika]

Duplicate

 

[VoG]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).