Exclude a row with duplicate values in Excel

Hi all
I need to sum rows in excel.
But there are rows with duplicate data..

e.g  If for a giveb two rows..  with column FileName
If the number [99123654] appears in Row 1 and row 2.
Only one row 1 will be calculate. Row two will be skipped.
This case may involve about 4 rows.. Hence only 1 row out of the 4 will be included in the calculation..

Thanks in Advance
ZH
ZURINETAsked:
Who is Participating?
 
Shanan212Commented:
=SUM(IF(FREQUENCY(C5:C9,C5:C9),C5:C9))

Change it as you wish and enter as array formula.

That is, once you finish modifying the formula, select the cell the formula is in, then press

'Ctrl + Shift + Enter' keys
0
 
NBVCCommented:
So are you just summing up a column of various FileNameIDs and just want to include only the first row of each unique FileName... or are you inputting the FileName somewhere and what to retrieve the value in the first row of that FileName's occurance in the column?
0
 
ZURINETAuthor Commented:
Hi NB_VC

This statement is correct

"So are you just summing up a column of various FileNameIDs and just want to include only the first row of each unique FileName"
0
 
NBVCCommented:
The simplest way would be to add a quick helper column to identify the first of each.

Assuming they are grouped together, and that the data starts in A2 and B2, then in C2 enter formula:

=IF(A2=A1,"",B2)

copied down

Then the total would be simply:

=SUM(C:C)

Does that work for you?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.