- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2008 July
- Summing Text

Subject: | Summing Text |

Posted by: | Paul (Msr…@TPx12.com) |

Date: | Sun, 13 Jul 2008 |

I have two columns of text

d s

d r

t s

p s

p r

t r

t r

d s

How do I write a formula to find out how many instances there are of d

in columna A that correspond to s in Column B? Should be two.

Is that sumprouct or sumif?

- Re: Summing Text posted by Rick Rothstein \(MVP - VB\) on Sun, 13 Jul 2008
- Re: Summing Text posted by P.Bastard on Sun, 13 Jul 2008