Excel Lookup Assistance

I have an excel spreadsheet with multiple tabs.  I am working on a tab called summary and I want column C to equal the sum of Tab all deals column M when column J = Civilian
Matt PinkstonAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
NBVCConnect With a Mentor Commented:
I thought you were going across multiple sheets.... I didn't pick up that it was one sheet...

if it's one sheet named all deals, then

=SUMIF('all deals'!J:J, "Civilian",'all deals'!M:M)
0
 
NBVCCommented:
Create a list of all the tabnames in your workbook somewhere, select that list and name it by typing a name in the NameBox just to the left, for example SheetNames

Then enter a formula like:

=SUMPRODUCT(SUMIF(INDIRECT("'"&SheetNames&"'!J:J"),"Civilian",INDIRECT("'"&SheetNames&"'!M:M")))
0
 
Matt PinkstonAuthor Commented:
all I am looking for is one formula for one column

sum of all deals column M when all deals column J = civilian
0
 
Matt PinkstonAuthor Commented:
isn't it something like this

=SUMIF(!all dealsJ:J, "Civilian", !all deals M:M)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.