mercredi 4 juillet 2018

Excel Sumifs with added criterias IF a condition is met

I wish to do a SUMIFS that adds range & criteria based on certain conditions. The logic is as follow

SUMIFS sum_range,
range1, criteria1,
range2, criteria2,
range3, criteria3,
IF(condition1)
    IF(condition2)
        (nothing we're done)
    ELSE
        range4, criteria4
ELSE
    IF(condition 2)
        range5, criteria5
    ELSE
        range4, criteria4
        range5, criteria5

So that my sumifs would extend as needed, from 3 ranges to 5 ranges if needed.

Aucun commentaire:

Enregistrer un commentaire