Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

If I want to sum only negative figures from column which contain both negative and positive figures which formula will I use?

user-image
Question added by Irfan Hamid ACCA
Date Posted: 2013/11/05
Zafar Iqbal
by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

agreed with Mr. Nijesh Mekkalayil

mohammed shafi ur rahman mohammed
by mohammed shafi ur rahman mohammed , Senior Accountant , Remix Tech LLC

A

A1  1000

A2  1000 A3  -1000 A4    500 A5   -600

 =sumif(A1:A5,"<0")

Nijesh Mekkalayil
by Nijesh Mekkalayil , Senior Accountant , Al Shalan Foodstuff Tr. LLC ( www.shaalanfoods.com)

=SUMIF(D3:D14,"<0"),where D3:D14 are the cells with -(ve) and +(ve) values. 

More Questions Like This