SUMIF and multiple criteria

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?
 
U

UCfts

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top