- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- SumIF full columns, multiple conditions

Subject: | SumIF full columns, multiple conditions |

Posted by: | Gupta A |

Date: | Tue, 23 May 2006 |

In column A:A, B:B, i have data. I want a formula to count the number of

times the two pieces of data appaer in the same row. For example if A:A

contains

1

2

3 and B:B contains

A

B

C

I would like it to count the number of times B appears next to the number 1.

I need this done for an entire column, and looking through past helps

questions I get the idea that pivot tables would be useful here, however I

dont want to use them. Is there any other solution? (In essence its a SUM if

formula with two conditions)

- Re: SumIF full columns, multiple conditions posted by mrice on Tue, 23 May 2006
- Re: SumIF full columns, multiple conditions posted by Bob Phillips on Tue, 23 May 2006