Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a spreadsheet with all our invoice and account code info on it.
Month Cost Site Code GL Code sub acct 3 $75.00 700441 5790 020 1 $735.00 700441 5790 020 7 $74.00 704200 5790 50 I have a budget spreadsheet with month along the columns and the account details down the rows JAN FEB MAR 5790 FACILITIES 020 Hazardous waste 50 Rubbish disposal Other Total 5790 FACILITIES 0 0 0 I am looking for a formula that will look for and sum up all the $ values for month 1 (Jan) that match code 700441 and 5790 and 020. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MAX value matching multiple criteria | Excel Worksheet Functions | |||
VLookup - Multiple Rows with Exact Matching Column 1 | Excel Discussion (Misc queries) | |||
Sorting and Matching criteria across rows to return a result in the last cell | Excel Worksheet Functions | |||
return multiple records matching multiple criteria | Excel Worksheet Functions | |||
Extract multiple records matching criteria from list | Excel Worksheet Functions |