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().
Thanks
For that I need to understand where is which column. If dates are in column A, next is B, when 1230 is in column C, not in column D. Perhaps you may provide sample file instead of copy/pasting info into the body of the post?
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().
- Thanks Sergei
That's awesome.
Would you kindly try to correct my formula, withs IFS syntax?
Thanks 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:
- Below is the full file as you requested.
MOD is 110, as I mentioned earlier.