Forum Discussion
Excel syntax for summing up values that satify 2 conditions
Afraid SUMIFS() doesn't work in such case, you can't use other functions within criteria. Alternatively you may add helper column to your data which returns TRUE or FALSE (or whatever your prefer) if base number is multiplier for values in another column or not. After that use that helper column in SUMIFS().
Actually it's the same, I only saved the file in Excel format to keep formulas and formatting, transformed source data to structured table (Ctrl+T) and use named parameters:
That's awesome.
Would you kindly try to correct my formula, withs IFS syntax?
Thanks
Elhilayla , you are welcome
- I truly appreciate
Thaks Afraid SUMIFS() doesn't work in such case, you can't use other functions within criteria. Alternatively you may add helper column to your data which returns TRUE or FALSE (or whatever your prefer) if base number is multiplier for values in another column or not. After that use that helper column in SUMIFS().