| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
Hi,
I would like to create some formulas that regonises a word in the first column and then adds up the number across from it. Thanks.... -- MickM |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula
Possibly
=SUMPRODUCT((A1:A20="Myword")*(B1:B20)) Mike "Mick" wrote: Hi, I would like to create some formulas that regonises a word in the first column and then adds up the number across from it. Thanks.... -- MickM |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula
why wouldn't you use SUMIF?
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mike H" wrote in message ... Possibly =SUMPRODUCT((A1:A20="Myword")*(B1:B20)) Mike "Mick" wrote: Hi, I would like to create some formulas that regonises a word in the first column and then adds up the number across from it. Thanks.... -- MickM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
