I have an excel file and want to do sum only negative value of a code.
Please refer my attachment.
refer my code in colomn h and total of these are coming from column f in column i
I have an excel file and want to do sum only negative value of a code.
Please refer my attachment.
refer my code in colomn h and total of these are coming from column f in column i
Regards
Pradeep Kumar Gupta
Gurgaon ( INDIA )
Hi use this:
=SUMIFS(F:F,E:E,H8,F:F,"<0")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks for nice suggestion
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks