Forum Discussion
Solved
Excel syntax for summing up values that satify 2 conditions
I've to sum up all values that are multiples of 123 and also came from the source on column B "xyz123". I should come up with IFS to satisfy 2 conditions i.e. 2 IFS How can I make that formula
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
That's awesome.
Would you kindly try to correct my formula, withs IFS syntax?
Thanks
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().
Elhilayla , you are welcome
- I truly appreciate
Thaks