SUMIF and multiple criteria
 

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?

SUMIF and multiple criteria
 

Please show sample of what you need

--
Greatly appreciated
Eva


"UCfts" wrote:

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?

SUMIF and multiple criteria
 

=sumproduct((a2:a22="???")*(b2:b22="this")*c2:c22)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"UCfts" wrote in message
...
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?

SUMIF and multiple criteria
 

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


"Eva" wrote:

Please show sample of what you need

--
Greatly appreciated
Eva


"UCfts" wrote:

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?