Lookup cells and count matching cells column

**Firemaster** · 09-17-2012, 11:36 AM

Hi guys, I have been trawling through your Forums and very impresssed at the excel knowledge here. So as i thought i would See if you could solve my (probably simple) Conundrum

This is what i want my spread sheet to do

Column A1:A250 Look for exact duplicate cells of a particular text (e.g. All cells in that range which have the text fred)
And in those corresponding cells Count the cell 3 columns to the right (e.g 3 cells have fred in And in the cells to right of the name each has a number, 4+5+6=15)

A5 = Fred C5 = 4
A10 = Fred C10 = 5
A200 = Fred C200=6

result = 15 For Fred

A1:A250 has many different Names in

I do hope thats plain enough. Like i said, in my head its simple but putting it into a forumla for excel, Just as well ask me to read chinese

**Kevin UK** · 09-17-2012, 11:40 AM

I suggest you rename your thread before the Mods see it.

http://www.excelforum.com/forum-rule...rum-rules.html

**TMS** · 09-17-2012, 11:40 AM

Look at SUMIF.

Regards, TMS

**Firemaster** · 09-17-2012, 11:53 AM

Originally Posted by TMShucks

Look at SUMIF.

Regards, TMS

I tried this
SUMIF(A1:A256,"Usersname",C1:C256)
problem is with this i would have to enter the precise name of the user where the "username" is
Also tried
=SUMIF(A1:A280,A2,C2:C280)

I think i have renamed the Title as requested

**TMS** · 09-17-2012, 12:31 PM

You would have to make the ranges absolute.

=SUMIF($A$1:$A$280,$A2,$C$2:$C$280)

**Firemaster** · 09-18-2012, 04:08 AM

Hi The sumif did work, The issue was with the log files i had, For some reason excel could not read the number in the cell, so although it said number 2 it read the cell as empty, i had to go through the whole worksheet and type over the top of the numbers for excel to recognise it (452 rows later) then sum if worked weird uh? i did try copy and paste but that didnt work either.
any way sorted cheers

**TMS** · 09-18-2012, 05:09 AM

Put a 1 in a spare cell. Copy that cell. Then select the "numbers" that are really text. Choose Paste Special | Operation=Multiply. Delete the "spare" cell. Done.

Regards, TMS