Thread
:
Sum of unique values within a range with blank cells
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
loook
external usenet poster
Posts: 1
Sum of unique values within a range with blank cells
Hi, how can I sum unique values within a range where some cells are
blank?
An example:
A
1 100
2 150
3
4 150
5 50
6
7 100
8 100
9 50
10 SUM = 300 (100 + 150 + 50)
Thanx for any suggestion.
look
Reply With Quote
loook
View Public Profile
Find all posts by loook