R rajkenya1 Member Oct 27, 2014 #1 Hi I am sure this is simple. In column E in the attached spreadsheet i have either F or V next to a line item. What i want is to add all the lines which have v and all the lines which have f in one year. Please suggest a formulae in cell d14 Attachments Book1.xlsx 52.1 KB · Views: 3
Hi I am sure this is simple. In column E in the attached spreadsheet i have either F or V next to a line item. What i want is to add all the lines which have v and all the lines which have f in one year. Please suggest a formulae in cell d14
R rajkenya1 Member Oct 27, 2014 #3 Hi Asheesh. Sorry the year is from colum f to j. Find amended spreadsheet Attachments Book1.xlsx 52.5 KB · Views: 4
K kchiba Active Member Oct 27, 2014 #4 Hi Raj, See attached file. It uses the SUMIF Attachments Book1 (1).xlsx 52.7 KB · Views: 4
Somendra Misra Excel Ninja Oct 27, 2014 #5 Hi Raj, Not Sure but see the file. Regards, Attachments Book1 (37).xlsx 52.9 KB · Views: 6
R rajkenya1 Member Oct 27, 2014 #6 Solved. Thank you Kchiba for the quick response and thanks Asheesh for looking into it as well. Thank you
Solved. Thank you Kchiba for the quick response and thanks Asheesh for looking into it as well. Thank you
