Formula help!

Copper Contributor

Help. I am trying to create an excel formal that will add up only the amounts that equal a specific description in column c,d and e. For example, column f is the sum should only be if column c is"Chair", d is "car" and e is "black".  I keep trying to create a ifsum formula and it is not working.

2 Replies

@mlb0133forgot to say this would be for the same row of data

Hello @mlb0133,

 

That would be like:

=SUMIFS(F:F,C:C,"chair",D:D,"car",E:E,"black")