Defined Names in an If Statement

  • Thread starter Thread starter SharonSmith
  • Start date Start date
S

SharonSmith

I have a worksheet called Tech in which there is a column I have defined as
SACS and another column I've defined as TOTAL. There are 3 possible values
in SACS column: 4300, 5200, or 6000 which are 'text' labels, not numbers
that are summed.

I have another worksheet in same workbook that is called Summary. I want to
sum the TOTALs of all the line items of the Tech worksheet according to the
three SACS values. So on the Summary I have a row per value.
B3 is 4300
C3 is 5200
D3 is 6000
Now in B4, C4 & D4 I want to create a calculation that sums all the line
items under the TOTAL column on Tech worksheet associated with 4300, 5200,
and 6000.
Question: How do I write the calculation using the name SACS?

=Sum(Total if SACS=4300) That's what I'm trying to accomplish.

Help? Thanx
 
I have a worksheet called Tech in which there is a column I have defined as
SACS and another column I've defined as TOTAL. There are 3 possible values
in SACS column: 4300, 5200, or 6000 which are 'text' labels, not numbers
that are summed.

I have another worksheet in same workbook that is called Summary. I want to
sum the TOTALs of all the line items of the Tech worksheet according to the
three SACS values. So on the Summary I have a row per value.
B3 is 4300
C3 is 5200
D3 is 6000
Now in B4, C4 & D4 I want to create a calculation that sums all the line
items under the TOTAL column on Tech worksheet associated with 4300, 5200,
and 6000.
Question: How do I write the calculation using the name SACS?

=Sum(Total if SACS=4300) That's what I'm trying to accomplish.

Help? Thanx
Click to expand...

I failed to mention that the calc I used: =If(SACS="4300", Sum(Total),)
does not return an error, but it also does not return any values.
 
Back
Top