Total the Amount with status

[webmax]

Dear Team,

I need the formula for the attached sheet.

I contains two sheets one is Raw Data and output

Based on the raw data i want the output using the formula which has three status like success, pending and failed.

The same now i using in pivot table but every time i have to change the data source and refresh the table.

So i looking formula based.

Regards
Shahul

 

[azumi]

Maybe, put in sheet "Output" on cell B2, copied down and cross

=SUMIFS('Raw Data'!$B$2:$B$14,'Raw Data'!$A$2:$A$14,$A2,'Raw Data'!$C$2:$C$14,B$1)

 

[vletm]

webmax
Think few more times about using Pivot.
Get ideas from this ...