| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif with multiple criteria | Excel Worksheet Functions | |||
| SUMPRODUCT / SUMIF on Multiple Worksheets with Multiple Criteria | Excel Discussion (Misc queries) | |||
| SUMIF WITH MULTIPLE CRITERIA | Excel Discussion (Misc queries) | |||
| sumif for multiple criteria | Excel Discussion (Misc queries) | |||
| SUMIF multiple criteria | Excel Discussion (Misc queries) | |||
Linear Mode
