| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum If
Hi - can comeone help me please
Into B21 I want to add the values of rows B2:B18 where ant of the rowsC2:C18 contain the word "Premier" tks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum If
Try,
=SUMPRODUCT((C2:C18="Premier")*(B2:B18)) Mike "Alex" wrote: Hi - can comeone help me please Into B21 I want to add the values of rows B2:B18 where ant of the rowsC2:C18 contain the word "Premier" tks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum If
=SUMIF(C2:C18,"Premier",B2:B18)
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alex" wrote in message ... Hi - can comeone help me please Into B21 I want to add the values of rows B2:B18 where ant of the rowsC2:C18 contain the word "Premier" tks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum If
Thanks both
Alex "Alex" wrote in message ... Hi - can comeone help me please Into B21 I want to add the values of rows B2:B18 where ant of the rowsC2:C18 contain the word "Premier" tks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
