sumif and sumifs with vsack

Copper Contributor

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

1 Reply

@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.