| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif problems
hi
i have a problem with the sumif. i have the following example Col. A Col. B John 5 Joe 10 John 6 John 7 I want to know the sum of John´s I have 5 Thanks for help. Have a great 2007. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sumif problems
=SUMPRODUCT(--(A1:A100="John"),--(B1:B1005),B1:B100)
"Ricardo" wrote: hi i have a problem with the sumif. i have the following example Col. A Col. B John 5 Joe 10 John 6 John 7 I want to know the sum of John´s I have 5 Thanks for help. Have a great 2007. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sumif problems
thanks for help
"Teethless mama" escreveu: =SUMPRODUCT(--(A1:A100="John"),--(B1:B1005),B1:B100) "Ricardo" wrote: hi i have a problem with the sumif. i have the following example Col. A Col. B John 5 Joe 10 John 6 John 7 I want to know the sum of John´s I have 5 Thanks for help. Have a great 2007. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Indirect and Sumif Syntax Problems | Excel Discussion (Misc queries) | |||
| sumif problems | Excel Discussion (Misc queries) | |||
| problems with sumif and countif | Excel Discussion (Misc queries) | |||
| Sumif Problems | Excel Discussion (Misc queries) | |||
| sumif alphanumeric problems | Excel Discussion (Misc queries) | |||
Linear Mode
