| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional sum
Hi experts,
I have column S in which there are only numbers i have column P in which the condition is put I would like, in A1, to sum all cells in column S where in column P the word 'closed' is put in. Any ideas? Thanks, Pierre -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200512/1 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
conditional sum
Hi Pierre,
=SUMIF(P:P,"closed",S:S) Ken Johnson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
conditional sum
Thanks Ken, this helps a lot but...
what if 'closed' is not hte only condition... i would like the sum of column S if in colum P it says Closed or lost... any ideas ? i've been fidling but no succes... Thanks, Pierre Ken Johnson wrote: Hi Pierre, =SUMIF(P:P,"closed",S:S) Ken Johnson -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200512/1 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
conditional sum
Hi Pierre,
How about: =SUMIF(P:P,"Closed",S:S) + SUMIF(P:P,"lost",S:S) Hope this helps! Ken Johnson |
| 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 | |||
| Multiple conditional on conditional format formula | Excel Programming | |||
| Multiple conditional on conditional format formula | Excel Programming | |||
![Pierre via OfficeKB.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
