Thread
:
ADD AN ITEM IN A FORMULA ONLY IF IT IS A NEGATIVE
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Biff
external usenet poster
Posts: 1,688
ADD AN ITEM IN A FORMULA ONLY IF IT IS A NEGATIVE
=SUMIF(A1:A5,"<0")
Biff
"tcazabon" wrote in message
...
I would like to add an item in a formula only if it is a negative number.
Reply With Quote
Biff
View Public Profile
Find all posts by Biff