software

How could i get the sum of a column that would not include in the total sum
any cells in another column that has certain info
ex: if any corresponding cells in column A=quot;springquot; then do not include in
total sum of cells in clumn b

Try...

=SUMIF(A1:A100,quot;lt;gt;Springquot;,B1:B100)

Hope this helps!

In article gt;,
blackstar gt; wrote:

gt; How could i get the sum of a column that would not include in the total sum
gt; any cells in another column that has certain info
gt; ex: if any corresponding cells in column A=quot;springquot; then do not include in
gt; total sum of cells in clumn b

=SUMIF(G16:G18,quot;lt;gt;springquot;,H16:H18)

quot;blackstarquot; wrote:

gt; How could i get the sum of a column that would not include in the total sum
gt; any cells in another column that has certain info
gt; ex: if any corresponding cells in column A=quot;springquot; then do not include in
gt; total sum of cells in clumn b

nope, didn't work only gave me the sum of from ex h16:h18 regardless of info
in cells g16:g18

quot;Jonathan Cooperquot; wrote:

gt; =SUMIF(G16:G18,quot;lt;gt;springquot;,H16:H18)
gt;
gt; quot;blackstarquot; wrote:
gt;
gt; gt; How could i get the sum of a column that would not include in the total sum
gt; gt; any cells in another column that has certain info
gt; gt; ex: if any corresponding cells in column A=quot;springquot; then do not include in
gt; gt; total sum of cells in clumn b

no dice, gives me a result of 0 every time. #'s are in column B quot;springquot; is
in column A formula is in column B

quot;Domenicquot; wrote:

gt; Try...
gt;
gt; =SUMIF(A1:A100,quot;lt;gt;Springquot;,B1:B100)
gt;
gt; Hope this helps!
gt;
gt; In article gt;,
gt; blackstar gt; wrote:
gt;
gt; gt; How could i get the sum of a column that would not include in the total sum
gt; gt; any cells in another column that has certain info
gt; gt; ex: if any corresponding cells in column A=quot;springquot; then do not include in
gt; gt; total sum of cells in clumn b
gt;

See Domenic's response for a better example. this works for me. If it is
still not working for you, I suggest you check to see if you perhaps have an
extra space or something in the cells that say spring. A trailing space can
through you off.
quot;blackstarquot; wrote:

gt; nope, didn't work only gave me the sum of from ex h16:h18 regardless of info
gt; in cells g16:g18
gt;
gt; quot;Jonathan Cooperquot; wrote:
gt;
gt; gt; =SUMIF(G16:G18,quot;lt;gt;springquot;,H16:H18)
gt; gt;
gt; gt; quot;blackstarquot; wrote:
gt; gt;
gt; gt; gt; How could i get the sum of a column that would not include in the total sum
gt; gt; gt; any cells in another column that has certain info
gt; gt; gt; ex: if any corresponding cells in column A=quot;springquot; then do not include in
gt; gt; gt; total sum of cells in clumn b

Just to be clear, do you want to sum Column B if the corresponding
values in Column A equals 'Spring' or if Column A doesn't equal
'Spring'.?

In article gt;,
blackstar gt; wrote:

gt; no dice, gives me a result of 0 every time. #'s are in column B quot;springquot; is
gt; in column A formula is in column B
gt;
gt; quot;Domenicquot; wrote:
gt;
gt; gt; Try...
gt; gt;
gt; gt; =SUMIF(A1:A100,quot;lt;gt;Springquot;,B1:B100)
gt; gt;
gt; gt; Hope this helps!
gt; gt;
gt; gt; In article gt;,
gt; gt; blackstar gt; wrote:
gt; gt;
gt; gt; gt; How could i get the sum of a column that would not include in the total
gt; gt; gt; sum
gt; gt; gt; any cells in another column that has certain info
gt; gt; gt; ex: if any corresponding cells in column A=quot;springquot; then do not include
gt; gt; gt; in
gt; gt; gt; total sum of cells in clumn b
gt; gt;

so i've put in quot;springquot; from a1:a4 and a5:a1000 has quot;summerquot; with #2 @ each
cell in column B... with the formula below it gives me the total of cell b1
to b1000 regardless of if its quot;springquot; or quot;summerquot; in cells a1 to a1000

quot;blackstarquot; wrote:

gt; no dice, gives me a result of 0 every time. #'s are in column B quot;springquot; is
gt; in column A formula is in column B
gt;
gt; quot;Domenicquot; wrote:
gt;
gt; gt; Try...
gt; gt;
gt; gt; =SUMIF(A1:A100,quot;lt;gt;Springquot;,B1:B100)
gt; gt;
gt; gt; Hope this helps!
gt; gt;
gt; gt; In article gt;,
gt; gt; blackstar gt; wrote:
gt; gt;
gt; gt; gt; How could i get the sum of a column that would not include in the total sum
gt; gt; gt; any cells in another column that has certain info
gt; gt; gt; ex: if any corresponding cells in column A=quot;springquot; then do not include in
gt; gt; gt; total sum of cells in clumn b
gt; gt;

i want the sum column B if column A equals spring. if it says anything other
than spring i don't want column B to take into account the values of B

quot;Domenicquot; wrote:

gt; Just to be clear, do you want to sum Column B if the corresponding
gt; values in Column A equals 'Spring' or if Column A doesn't equal
gt; 'Spring'.?
gt;
gt; In article gt;,
gt; blackstar gt; wrote:
gt;
gt; gt; no dice, gives me a result of 0 every time. #'s are in column B quot;springquot; is
gt; gt; in column A formula is in column B
gt; gt;
gt; gt; quot;Domenicquot; wrote:
gt; gt;
gt; gt; gt; Try...
gt; gt; gt;
gt; gt; gt; =SUMIF(A1:A100,quot;lt;gt;Springquot;,B1:B100)
gt; gt; gt;
gt; gt; gt; Hope this helps!
gt; gt; gt;
gt; gt; gt; In article gt;,
gt; gt; gt; blackstar gt; wrote:
gt; gt; gt;
gt; gt; gt; gt; How could i get the sum of a column that would not include in the total
gt; gt; gt; gt; sum
gt; gt; gt; gt; any cells in another column that has certain info
gt; gt; gt; gt; ex: if any corresponding cells in column A=quot;springquot; then do not include
gt; gt; gt; gt; in
gt; gt; gt; gt; total sum of cells in clumn b
gt; gt; gt;
gt;

And, A1:A4, ONLY have the value spring typed in. No other text in those cells?

quot;blackstarquot; wrote:

gt; so i've put in quot;springquot; from a1:a4 and a5:a1000 has quot;summerquot; with #2 @ each
gt; cell in column B... with the formula below it gives me the total of cell b1
gt; to b1000 regardless of if its quot;springquot; or quot;summerquot; in cells a1 to a1000
gt;
gt; quot;blackstarquot; wrote:
gt;
gt; gt; no dice, gives me a result of 0 every time. #'s are in column B quot;springquot; is
gt; gt; in column A formula is in column B
gt; gt;
gt; gt; quot;Domenicquot; wrote:
gt; gt;
gt; gt; gt; Try...
gt; gt; gt;
gt; gt; gt; =SUMIF(A1:A100,quot;lt;gt;Springquot;,B1:B100)
gt; gt; gt;
gt; gt; gt; Hope this helps!
gt; gt; gt;
gt; gt; gt; In article gt;,
gt; gt; gt; blackstar gt; wrote:
gt; gt; gt;
gt; gt; gt; gt; How could i get the sum of a column that would not include in the total sum
gt; gt; gt; gt; any cells in another column that has certain info
gt; gt; gt; gt; ex: if any corresponding cells in column A=quot;springquot; then do not include in
gt; gt; gt; gt; total sum of cells in clumn b
gt; gt; gt;