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 simplified version of course. IN reality, it's a formula I need to say, If A specific customer is in the Status Pending, Approved, WIP then sum the total Revenue.
I cant seem to do this without Adding the SumIFS individually. All help welcome.
=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.
