Adding cells with a particular comment

N

NC

Hi all,

is there any simple to add all cells in a row which have a particular
comment without using macro.

pls help.

Regards,
NC
 
N

NC

well i can use it for particular values but how to use it with
comments. My problem is a particular comment for e.g "reject" or
"accept" ia added to that cell, & you want to sum the cells with this
partcular comment only.
 
N

NC

well i can use sumif for particular values but how to use it with
comments. My problem is a particular comment for e.g "reject" or
"accept" is added to that cell, & i want to sum the cells with this
partcular comment only.
 
D

Dave Peterson

Not without a macro.
Hi all,

is there any simple to add all cells in a row which have a particular
comment without using macro.

pls help.

Regards,
NC
 
Top