[Solved] Formula for checking one column and adding another

crusch · Post by **crusch** » Sat May 12, 2018 7:25 pm

Hello,
I am trying to set up formula that will check the values in one column and then sum the balance in another column.
For example:

If E3 reads 1 then add B3.

But I want it to read every row in column E and add all the corresponding numbers from those rows in column B.

Post by **FJCC** » Sat May 12, 2018 7:40 pm

Use the SUMIF() function

Code: Select all

=SUMIF(E2:E11;1;B2:B11)

crusch · Post by **crusch** » Sat May 12, 2018 7:42 pm

That worked. Thank you so much!

IsabelDalhousie · Post by **IsabelDalhousie** » Mon May 21, 2018 1:03 am

Is it possible to look up first column for a category code, say the first column identifies category X, Y or Z. then I want the second column to use that category code in a conditional sum ...i tried this in my cell B1

sumif(A10:A1000;"X";B10:B1000)

hoping the sum of B10:B1000 would add only those values where column A rows show category X

I'm missing something ... would appreciate any assist!

Post by **FJCC** » Mon May 21, 2018 1:19 am

Your formula should work. See the attached for an example. What value are you getting on your data? Is it zero or are all numbers being summed?

IsabelDalhousie · Post by **IsabelDalhousie** » Mon May 21, 2018 1:41 am

I tried again and it worked! Thanks for giving encouragement FJCC

[Solved] Formula for checking one column and adding another

[Solved] Formula for checking one column and adding another

Re: IF THEN Formula for checking one column and adding anoth

Re: IF THEN Formula for checking one column and adding anoth

Re: Formula for checking one column and adding another

Re: [Solved] Formula for checking one column and adding anot

Re: [Solved] Formula for checking one column and adding anot