Forum Discussion
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().
19 Replies
- Very much appreciated.
Thanks Herbert I can't actually guess what is meant with source xyz123.
But i can suggest a formula to add all numbers that are multiples of 123 and that are in range A3:A6.
=SUM(IF(MOD(A3:A6,123)=0,A3:A6))
The formula has to be entered as arrayformula with ctrl+shift+enter.
Very much appreciated my friend
Sorry for the confusion>
I mean to say that the inputs come from different sources, what is required is a specific source>
For instance, 20/07/2021 source is Recept - VFC ***tdG it is a multiple of 123
7/16/2021 Envoi - VFC ***bTz 2077.5 7/16/2021 Recept - VFC ***86m 450.03 2527.53 7/19/2021 ROuioRS *** _V 2225.54 7/19/2021 MXU MykCHE _F 2216.58 7/19/2021 YZUAN MerCHE _F 2166.09 7/20/2021 Recept - VFC ***tdG 1230 3398.06 7/21/2021 SEP A: 05306449863 3396.56 - so, we need ifs, to satisfy these 2 conditions
