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