Hi team ,
Hoping for some help!
Looking for a way to sum data using sumifs ( maybe) when you have multiple criteria, but the criteria changes through the data set. Its easy to write the formula for criteria that stays constant, but is there an easier way than manually changing the criteria ?
My example in the attachment shows A- D , each contain a number of colours.
To Sum say A and white =sumifs(Column C, Column A, "A",Column B , "White) . Would use cell references for the criteria range usually , but have just used the columns in this example.
But as I go down the list I want sums for A & Red, A & Blue, B & White, B & Red etc.
What is the best way to do this please.
Thanks!
Bookmarks