Is there a way to use the text value of cells with a conditional statement such as sumifs so that on one sheet I can have all the expenses#   A           B          C1   R. Tusk     Travel     1,717.092   Frank U     Travel       634.673   R. Tusk     Meal          50.004   Frank U     Supplies   1,336.665   R. Tusk     Meal          10.006   R. Tusk     Meal          55.007   R. Tusk     Ent       23,803.978   R. Tusk     Pol. Don. 24,483.919   R. Tusk     Meal          10.0310  R. Tusk     Ent        1,191.6211  Frank U     Pol. Don. 40,493.1412  R. Tusk     Pol. Don. 10,014.0113  Frank U     Travel       100.0013  Frank U     Travel       100.00And on the other sheet I can have essentially one formula the following:Politician      Meal        Travel    Pol. Don.        Ent     SuppliesR. Tusk         XXXX.XX    XXXX.XX      XXXX.XX    XXXX.XX      XXXX.XXFrank U         XXXX.XX    XXXX.XX      XXXX.XX    XXXX.XX      XXXX.XX  I was thinking=SUMIFS('Sheet1'!C:C,'Sheet1'!B:B,=T(B$1),'Sheet1'!A:A),=T($A2))But that and other slight variations only gave me error, n/a, and #value!Update=SUM(FILTER('Sheet1'!$C:$C,'Sheet1'!$B:$B=B$1,'Sheet1'!$A:$A=$A2))For those playing at home, this worked.
Google Spreadsheets SUMIFS with Text Value of Cells
google spreadsheets