SumIF full columns, multiple conditions

Giganews Newsgroups
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)

Replies