S sachar Member Oct 12, 2017 #1 Dear All, With reference to the attach a sample file, is there any formula to get the sum of the only negative value of the total rows as I got the answer in cell “B20” by manual calculation. Thanking you. Attachments example file_sumif formula.xlsx 14.5 KB · Views: 3
Dear All, With reference to the attach a sample file, is there any formula to get the sum of the only negative value of the total rows as I got the answer in cell “B20” by manual calculation. Thanking you.
N NARAYANK991 Excel Ninja Oct 12, 2017 #2 Hi , This is a duplicate post ; please look at your earlier thread here : https://chandoo.org/forum/threads/sumif-formula-mistake.36072/ Narayan
Hi , This is a duplicate post ; please look at your earlier thread here : https://chandoo.org/forum/threads/sumif-formula-mistake.36072/ Narayan