Software

Ask something
Question Locked

Excel Formula

0 helpful
5 replies

by a former member

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a series of report and index table. How do i set the formula if i want to count when cell A1 = cell B1, the points = cell C1?

E.g.

ColumnA
1. ABC
2. ABC
3. GHI

ColumnB
1. ABC
2. DEF
3. GHI

ColumnC
1. 5
2. 4
3. 6

5 replies

by Former member

Clarifications

by terry.walters

In column D, put =if(a1=b1,c1,"") then SUM column D. You can always use another column to hold the result and 'hide' it from view if you don't want anyone to see it.

by Former member

Hi, Thanks.

I tried using the IF functions. But can't get it rite as i will require the formula to be if(a1=b1,c1), if a1=b2=c2, a1=b3=c3.

So how do i go about it?

by terry.walters

Hi

Try this instead in column D

=VLOOKUP(A1,$B$1:$C$3,2,FALSE)

this looks at the value in A1 for a match in B1:B3 and if found returns the value in Col C for the row found.

by larryd4

=IIF(a1=b1,c1,IIF(a1=b2 and a1=c2, c2,IIF(a1=b3 and a1=c3,c3,a1)))

This discussion is closed to new replies.