Forum Discussion

Carol_J's avatar
Carol_J
Copper Contributor
Nov 29, 2018

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 exotic just a simple one.  It give me the field error which I don't know what to do to fix it.

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

      I will try the colon to see if that works.  Thanks

    • 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