Forum Discussion

Carol_J's avatar
Carol_J
Copper Contributor
Nov 29, 2018
Solved

Spreadsheet Formula

Hi,'   For some reason when I try to do a sum formula in excel on a document imported from Capital One Credit Card it will not accept the formula.  The formula I am using is =sum(f2.f392).  Nothing...
excel
  • Drew208's avatar
    Drew208
    Nov 29, 2018
    I could not repeat your results. My Excel 2016 auto-corrected the =sum(f2.f392) to =sum(f2:f392), replaced the period with a colon.
Drew208's avatar
Drew208
Copper Contributor
Nov 29, 2018
I could not repeat your results. My Excel 2016 auto-corrected the =sum(f2.f392) to =sum(f2:f392), replaced the period with a colon.
Carol_J's avatar
Carol_J
Copper Contributor
Nov 29, 2018

Thanks for your help.  I changed the period to a colon and that worked.

 

 

Resources