SumIf Formula

  • Thread starter Thread starter Storm
  • Start date Start date
S

Storm

Hello there.

I am trying to add a sum range whose headers are equal to a specific one.

Row 1 will have the headers (Texas, NV, CA). Row 2 will have the
corresponding sales for either TX, NV or CA.

How can I say add the values in row 2 only if row 1's header = TX and NV?

Your help is appreciated. Thank you.
 
=SUMIF(1:1,"TX",2:2)
=SUMIF(1:1,"NV",2:2)
=SUMIF(1:1,"CA",2:2)

HTH,
Bernie
MS Excel MVP
 
Hi Bernie, so there is no way then of saying if 1:1 = TX or NV then get the
sum of their values in row 2? I have to do multiple sumif statements and
just separating them with "+"?

thanks.
 
That is the easiest...

=SUMIF(1:1,"TX",2:2) + SUMIF(1:1,"NV",2:2)

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ISTEST Function 7
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
excluding column headers from formulas 3
VlOOKUP/MATCH/INDEX 2
How to add a "running count" to cells with matching data 2
Need help with merging Excel worksheets and deleting unwanted columns 3
Column header for Max value? Index/array function? 5
Array Formulas with multiple criteria in the same row? 6

Back
Top