Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif???
If column A contains names of colors (A1=orange, A2=yellow, A3=orange, etc)
and column B contains numbers (B1=3, B2=7, B3=8, etc.), can I create a formula to sum all numbers in column B whose corresponding color in column A is "orange"? For example, A1 and A3 are "orange", so the formula delivers "11", the sum of B1 (3) and B2 (8). Thanks. -- Jeanette |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif???
The Excel help on SUMIF explains exactly what you need to do and shows an
example. In your case you need =SUMIF(A1:A100,"orange",B1:B100). You may need to amend the row range. It doesn't matter what cell you put the formula in, as long as it isn't in one of the ranges in the formula. -- Ian -- "Jeanette" wrote in message ... If column A contains names of colors (A1=orange, A2=yellow, A3=orange, etc) and column B contains numbers (B1=3, B2=7, B3=8, etc.), can I create a formula to sum all numbers in column B whose corresponding color in column A is "orange"? For example, A1 and A3 are "orange", so the formula delivers "11", the sum of B1 (3) and B2 (8). Thanks. -- Jeanette |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif???
Gee, I feel stupid. I didn't understand the difference between "range" and
"sum range" before. Now I do. Many thanks, Ian. -- Jeanette "Ian" wrote: The Excel help on SUMIF explains exactly what you need to do and shows an example. In your case you need =SUMIF(A1:A100,"orange",B1:B100). You may need to amend the row range. It doesn't matter what cell you put the formula in, as long as it isn't in one of the ranges in the formula. -- Ian -- "Jeanette" wrote in message ... If column A contains names of colors (A1=orange, A2=yellow, A3=orange, etc) and column B contains numbers (B1=3, B2=7, B3=8, etc.), can I create a formula to sum all numbers in column B whose corresponding color in column A is "orange"? For example, A1 and A3 are "orange", so the formula delivers "11", the sum of B1 (3) and B2 (8). Thanks. -- Jeanette |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif???
Glad to help. Thanks for the feedback.
-- Ian -- "Jeanette" wrote in message ... Gee, I feel stupid. I didn't understand the difference between "range" and "sum range" before. Now I do. Many thanks, Ian. -- Jeanette "Ian" wrote: The Excel help on SUMIF explains exactly what you need to do and shows an example. In your case you need =SUMIF(A1:A100,"orange",B1:B100). You may need to amend the row range. It doesn't matter what cell you put the formula in, as long as it isn't in one of the ranges in the formula. -- Ian -- "Jeanette" wrote in message ... If column A contains names of colors (A1=orange, A2=yellow, A3=orange, etc) and column B contains numbers (B1=3, B2=7, B3=8, etc.), can I create a formula to sum all numbers in column B whose corresponding color in column A is "orange"? For example, A1 and A3 are "orange", so the formula delivers "11", the sum of B1 (3) and B2 (8). Thanks. -- Jeanette |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif???
You can also use:
=sumproduct(--(a1:a10="yellow")*(B1:b10)) Thanks "Jeanette" wrote: Gee, I feel stupid. I didn't understand the difference between "range" and "sum range" before. Now I do. Many thanks, Ian. -- Jeanette "Ian" wrote: The Excel help on SUMIF explains exactly what you need to do and shows an example. In your case you need =SUMIF(A1:A100,"orange",B1:B100). You may need to amend the row range. It doesn't matter what cell you put the formula in, as long as it isn't in one of the ranges in the formula. -- Ian -- "Jeanette" wrote in message ... If column A contains names of colors (A1=orange, A2=yellow, A3=orange, etc) and column B contains numbers (B1=3, B2=7, B3=8, etc.), can I create a formula to sum all numbers in column B whose corresponding color in column A is "orange"? For example, A1 and A3 are "orange", so the formula delivers "11", the sum of B1 (3) and B2 (8). Thanks. -- Jeanette |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Need help with SUMIF | Excel Discussion (Misc queries) | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |