| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum of 1 column if info in another = specific text
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="spring" then do not include in total sum of cells in clumn b |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum of 1 column if info in another = specific text
Try...
=SUMIF(A1:A100,"<Spring",B1:B100) Hope this helps! In article , blackstar wrote: 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="spring" then do not include in total sum of cells in clumn b |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum of 1 column if info in another = specific text
no dice, gives me a result of 0 every time. #'s are in column B "spring" is
in column A formula is in column B "Domenic" wrote: Try... =SUMIF(A1:A100,"<Spring",B1:B100) Hope this helps! In article , blackstar wrote: 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="spring" then do not include in total sum of cells in clumn b |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum of 1 column if info in another = specific text
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 , blackstar wrote: no dice, gives me a result of 0 every time. #'s are in column B "spring" is in column A formula is in column B "Domenic" wrote: Try... =SUMIF(A1:A100,"<Spring",B1:B100) Hope this helps! In article , blackstar wrote: 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="spring" then do not include in total sum of cells in clumn b |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum of 1 column if info in another = specific text
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 "Domenic" wrote: 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 , blackstar wrote: no dice, gives me a result of 0 every time. #'s are in column B "spring" is in column A formula is in column B "Domenic" wrote: Try... =SUMIF(A1:A100,"<Spring",B1:B100) Hope this helps! In article , blackstar wrote: 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="spring" then do not include in total sum of cells in clumn b |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum of 1 column if info in another = specific text
In that case, try...
=SUMIF(A1:A100,"Spring",B1:B100) Hope this helps! In article , blackstar wrote: 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 "Domenic" wrote: 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 , blackstar wrote: no dice, gives me a result of 0 every time. #'s are in column B "spring" is in column A formula is in column B "Domenic" wrote: Try... =SUMIF(A1:A100,"<Spring",B1:B100) Hope this helps! In article , blackstar wrote: 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="spring" then do not include in total sum of cells in clumn b |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum of 1 column if info in another = specific text
so i've put in "spring" from a1:a4 and a5:a1000 has "summer" 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 "spring" or "summer" in cells a1 to a1000 "blackstar" wrote: no dice, gives me a result of 0 every time. #'s are in column B "spring" is in column A formula is in column B "Domenic" wrote: Try... =SUMIF(A1:A100,"<Spring",B1:B100) Hope this helps! In article , blackstar wrote: 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="spring" then do not include in total sum of cells in clumn b |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum of 1 column if info in another = specific text
And, A1:A4, ONLY have the value spring typed in. No other text in those cells?
"blackstar" wrote: so i've put in "spring" from a1:a4 and a5:a1000 has "summer" 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 "spring" or "summer" in cells a1 to a1000 "blackstar" wrote: no dice, gives me a result of 0 every time. #'s are in column B "spring" is in column A formula is in column B "Domenic" wrote: Try... =SUMIF(A1:A100,"<Spring",B1:B100) Hope this helps! In article , blackstar wrote: 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="spring" then do not include in total sum of cells in clumn b |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum of 1 column if info in another = specific text
Ok. I know I'm late in the game here but I'll give it a shot. I think what you mean is that if the cells in column A contain the word spring then include the corresponding value in column B for your sum. I used the range A1:A14 and B1:B14. You can expand as needed. =SUMPRODUCT(--(A2:A14="spring"),(B2:B14)) If you mean to sum the values in B where the corresponding value in A does not equal spring than, =SUMPRODUCT(--(A2:A14<"spring"),(B2:B14)) -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=508160 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum of 1 column if info in another = specific text
in the specific example i gave you yes. but in the actual uses of this
function i'll need, some of those cells MIGHT have other values than spring, such as summer etc..so i need excel to know only to include the cells IF they say spring... and another cell would have a formula that would give me the sum only IF they say summer..etc etc "Jonathan Cooper" wrote: And, A1:A4, ONLY have the value spring typed in. No other text in those cells? "blackstar" wrote: so i've put in "spring" from a1:a4 and a5:a1000 has "summer" 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 "spring" or "summer" in cells a1 to a1000 "blackstar" wrote: no dice, gives me a result of 0 every time. #'s are in column B "spring" is in column A formula is in column B "Domenic" wrote: Try... =SUMIF(A1:A100,"<Spring",B1:B100) Hope this helps! In article , blackstar wrote: 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="spring" then do not include in total sum of cells in clumn b |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum of 1 column if info in another = specific text
=SUMIF(G16:G18,"<spring",H16:H18)
"blackstar" wrote: 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="spring" then do not include in total sum of cells in clumn b |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum of 1 column if info in another = specific text
nope, didn't work only gave me the sum of from ex h16:h18 regardless of info
in cells g16:g18 "Jonathan Cooper" wrote: =SUMIF(G16:G18,"<spring",H16:H18) "blackstar" wrote: 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="spring" then do not include in total sum of cells in clumn b |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum of 1 column if info in another = specific text
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. "blackstar" wrote: nope, didn't work only gave me the sum of from ex h16:h18 regardless of info in cells g16:g18 "Jonathan Cooper" wrote: =SUMIF(G16:G18,"<spring",H16:H18) "blackstar" wrote: 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="spring" then do not include in total sum of cells in clumn b |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| another text to column problem | Excel Worksheet Functions | |||
Hybrid Mode
