Counting a cell based on the content of adjoining cell

**themax16** · 06-02-2008, 01:46 PM

Hey,

I am trying to count some numbers from colum (h) but only the ones that have the phrase 'text' in the cell directly next to it ( colum G).
any help would be great.

Thanks

James

**NBVC** · 06-02-2008, 01:49 PM

Try

=Sumif(G:G,"Text",H:H)

**themax16** · 06-02-2008, 02:07 PM

thanks for that, but I think I may have misrepresented my question.
I want each occasion then the word text is in for example G2, the contents of H2 to be replicated I2.

How's this best done?

Thanks again

James

**Shijesh Kumar** · 06-02-2008, 02:14 PM

Type the below formula in I2.
It will replicate the content of H2 in I2 if G2 is "Text"

Please Login or Register  to view this content.

**themax16** · 06-02-2008, 02:19 PM

This seems to recognise that then 'text' is in the cell that it should do something but leaves the cell containing " " - Nothing rather then a replication of the data in cell H.

**NBVC** · 06-02-2008, 02:22 PM

Is it just the word "text" that would be contained in G2 or is "text" a substring of what's in G2?

if so, try

=if(Isnumber(search("Text",G2)),H2,"")

**themax16** · 06-02-2008, 02:36 PM

That works an absolute treat,

Thanks for all your help guys!

James

Counting a cell based on the content of adjoining cell

LinkBack

Thread Tools

Rate This Thread

Display

Counting a cell based on the content of adjoining cell

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions