Forum Discussion
Adding SumIFS
Hi All. I am trying to add SumIFS 4 columns Customer, Status, Days, Revenue. I need to sum the total revenue of a customer when the status is in both Pending and Done. this is a simplif...
=SUMPRODUCT(SUMIFS(Table1[Revenue],Table1[Status],{"Pending","Done"}))
You can try this formula. For your actual data it should be easier to use SUMPRODUCT without SUMIFS.
