« previous next »
Pages: [1]

Author Topic: Run Time Error  (Read 15200 times)

Schim79

  • Newbie
  • *
  • Posts: 1
    • View Profile
Run Time Error
« on: November 21, 2021, 01:44:42 pm »
This was posted by another user earlier in the year and I am not sure if it was resolved as I am getting the same error.

Anytime I exit to home I get the following popup

Run-time error '1004'
Unable to get the SumIfs property of the WorkSheetFunction class.

Any help would be greatly appreciated. Thanks!
Logged

Scott

  • Administrator
  • Sr. Member
  • *****
  • Posts: 438
  • https://mycostpro.com
    • View Profile
    • MyCostPro
Re: Run Time Error
« Reply #1 on: November 22, 2021, 04:17:21 pm »
Hi,
On the Sold item tab, f you look at the hidden column in the red Expense section, "Sales Tax on Purchase" (column AP), there may be a formula error in one of the rows.
If you arent using that column you can simply delete all of the entries for all of the rows, or find the row with the error and delete it.

If you have any trouble with that or would rather have me look at it, please send your file to support@mycostpro.com
Logged

intelanalyst78

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: Run Time Error
« Reply #2 on: November 24, 2021, 06:28:39 pm »
What if we are collecting sales tax and want that data?  Same error
Logged

Scott

  • Administrator
  • Sr. Member
  • *****
  • Posts: 438
  • https://mycostpro.com
    • View Profile
    • MyCostPro
Re: Run Time Error
« Reply #3 on: November 24, 2021, 07:52:44 pm »
The mentioned column is specifically for sales tax on purchases, not the sales tax that you collect for the buyers.
It is fine to keep that data though, you will just need to repleace the formula of the error cell with the formula from directly above it.

If you cant find the error formula please feel free to send me your file.
Logged
Pages: [1]
« previous next »