subject:"$$Excel\-Macros$$ Need help with formula\:\("

Re: $$Excel-Macros$$ Need help with formula:(

2015-01-09 Thread Vaibhav Joshi

Hi You can do it using function sumifs Share sample data in excel sheet if you need further help.. Cheers!! ᐧ On Fri, Jan 9, 2015 at 7:39 PM, Janani Rajagopalan wrote: > I have the below data. I want to dynamically sum the Value column when the > CID and FID are the same and calculate value/t

$$Excel-Macros$$ Need help with formula:(

2015-01-09 Thread Janani Rajagopalan

I have the below data. I want to dynamically sum the Value column when the CID and FID are the same and calculate value/total value. Total Value = -3,000,000 Data Set CID FID Type Value 130358708 198733143 L -283296.27 123218808 700636266 L -11094494.2 001973308 500381594 L -102677357 0