IF function
Hi, thanks for the help.
"FSt1" wrote:
hi
might be better to use sumif.
=sumif(B2:B10,"transfer",A2:A10)
regards
FSt1
"freebee" wrote:
Hi, I want to learn how to sum cells with negative number with certain text
description, for example, B2=5, C2=stay, B3=-10, C3=transfer, B4=-3,
C4=transfer
I want A1 to sum only cells with adjacent colum with text "transfer"? Do I
use IF function?
Thanks.
|