| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Sum
Hi all!
I need a help to make a function to do some work for me. In my worksheet, I have two columns. The first is about descriptions, and the second about values. Like this: A B 1 Z 1 2 Z 3 3 Y 2 3 Z 8 So, I need to put in a cell, the sum of the values which have description equal 'Z'. Somebody could help, please? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Sum
=SUMIF(A:A,"Z",B:B)
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Yuki" wrote: Hi all! I need a help to make a function to do some work for me. In my worksheet, I have two columns. The first is about descriptions, and the second about values. Like this: A B 1 Z 1 2 Z 3 3 Y 2 3 Z 8 So, I need to put in a cell, the sum of the values which have description equal 'Z'. Somebody could help, please? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Sum
Try
=SUMIF(A1:A10,"z",B1:B10) Mike "Yuki" wrote: Hi all! I need a help to make a function to do some work for me. In my worksheet, I have two columns. The first is about descriptions, and the second about values. Like this: A B 1 Z 1 2 Z 3 3 Y 2 3 Z 8 So, I need to put in a cell, the sum of the values which have description equal 'Z'. Somebody could help, please? Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Sum
=SUMPRODUCT(--(A1:A100="Z"),(B1:B100))
adjust 100 to your range You can also use =SUMPRODUCT(--(A1:A100=A1),(B1:B100)) -- -Sheeloo ------------------------------------- Pl. click ''Yes'' if this was helpful... "Yuki" wrote: Hi all! I need a help to make a function to do some work for me. In my worksheet, I have two columns. The first is about descriptions, and the second about values. Like this: A B 1 Z 1 2 Z 3 3 Y 2 3 Z 8 So, I need to put in a cell, the sum of the values which have description equal 'Z'. Somebody could help, please? Thanks! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Sum
You can use the SUMIF function
=SUMIF(A:A,"=Z",B:B) -- If this post helps click Yes --------------- Jacob Skaria "Yuki" wrote: Hi all! I need a help to make a function to do some work for me. In my worksheet, I have two columns. The first is about descriptions, and the second about values. Like this: A B 1 Z 1 2 Z 3 3 Y 2 3 Z 8 So, I need to put in a cell, the sum of the values which have description equal 'Z'. Somebody could help, please? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
| Conditional Rank (or rather, Conditional Range) | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Linear Mode
