Forum Discussion

shankar236's avatar
shankar236
Copper Contributor
Jan 22, 2023

sumif and sumifs with vsack

i am trying to sum multiple ranges using sumif or sumifs with vstack "there is  a problem with this formula" window comes. ple

Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jan 22, 2023

    shankar236 When that window comes up one usually has made a typo in the formula. Most often commas are used to separate arguments where the local Excel system expects semi-colons, or vice-versa. Or brackets are placed incorrectly (too many or not enough) and Excel can't figure out how to fix it.

     

    So, please show the formula that you wrote. Otherwise it will be impossible to help.