SUMIF and multiple criteria

  • Thread starter Thread starter UCfts
  • Start date Start date
U

UCfts

I have a spread sheet with approx 3000 rows of info

The columns A and D of information have thee the criteria I would like to use.
Column A is a 4-character alpha-numeric field
Column D is a Alpha field

For each instance of the value in column A which meets the criteria in colum
D, I need to SUM column C.

Can anyone help?
 
Equip# Account Total Cost Transaction Code
4000 RV49 56 ADMINFEE
4002 BX79 56 ADMINFEE
4003 EV11 56 ADMINFEE
4009 TT61 346.89 DEPR
4026 CU21 283.95 DEPR
4053 TT38 234.26 DEPR
4063 GA13 288.28 DEPR
4000 RV49 -10 MISC
4002 BX79 -10 MISC
4003 EV11 -10 MISC
4004 RV05 22 MISC
4005 EL93 -10 MISC
4009 TT61 75.64 STIP
4026 CU21 51.5 STIP
4053 TT38 43.21 STIP
4063 GA13 25.02 STIP
 
Back
Top