| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding values in column D where cell in column A contains certain
Hi Folks,
Can anyone advise whether it's possible to add together all cells in column D where the cell in the same row and column A contains specific text? Thanks, Will Francis |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding values in column D where cell in column A contains certain
Hi Will,
yes, not hard =SUMIF(D:D,"value",A:A) -- HTH Bob Phillips "William Francis" wrote in message ... Hi Folks, Can anyone advise whether it's possible to add together all cells in column D where the cell in the same row and column A contains specific text? Thanks, Will Francis |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding values in column D where cell in column A contains cert
Thanks for that Bob. I have tried that, however this doesn't appear to work
as some cells only contain this text as part of the cell value, and not necessarily at the start of the cell? Sorry for not explaining that earlier. Thanks, Will "Bob Phillips" wrote: Hi Will, yes, not hard =SUMIF(D:D,"value",A:A) -- HTH Bob Phillips "William Francis" wrote in message ... Hi Folks, Can anyone advise whether it's possible to add together all cells in column D where the cell in the same row and column A contains specific text? Thanks, Will Francis |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding values in column D where cell in column A contains cert
Okay, next version :-)
=SUMIF(D:D,"*value*",A:A) -- HTH Bob Phillips "William Francis" wrote in message ... Thanks for that Bob. I have tried that, however this doesn't appear to work as some cells only contain this text as part of the cell value, and not necessarily at the start of the cell? Sorry for not explaining that earlier. Thanks, Will "Bob Phillips" wrote: Hi Will, yes, not hard =SUMIF(D:D,"value",A:A) -- HTH Bob Phillips "William Francis" wrote in message ... Hi Folks, Can anyone advise whether it's possible to add together all cells in column D where the cell in the same row and column A contains specific text? Thanks, Will Francis |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding values in column D where cell in column A contains cert
That's great Bob, thanks for your help.
Thanks, Bob. "Bob Phillips" wrote: Okay, next version :-) =SUMIF(D:D,"*value*",A:A) -- HTH Bob Phillips "William Francis" wrote in message ... Thanks for that Bob. I have tried that, however this doesn't appear to work as some cells only contain this text as part of the cell value, and not necessarily at the start of the cell? Sorry for not explaining that earlier. Thanks, Will "Bob Phillips" wrote: Hi Will, yes, not hard =SUMIF(D:D,"value",A:A) -- HTH Bob Phillips "William Francis" wrote in message ... Hi Folks, Can anyone advise whether it's possible to add together all cells in column D where the cell in the same row and column A contains specific text? Thanks, Will Francis |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding values across a row based on a corresponding column value | Excel Worksheet Functions | |||
| adding up vlookup values in one column and in between them | Excel Discussion (Misc queries) | |||
| adding up vlookup values in one column and in between them | Excel Worksheet Functions | |||
| Adding multiple values in one column based on multiple values of the same value (text) in another column | Excel Discussion (Misc queries) | |||
| Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
![William Francis[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
