Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I create a formula in excel with using 2 columns of info?
=SUMIF(B2:B24,4,A2:A24)
=SUMIF(B2:B24,3,A2:A24) =SUMIF(B2:B24,2,A2:A24) B is the priority, and A is the amount that is being summed. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i create a countif formula in excel? | Excel Worksheet Functions | |||
can i create formula giving totals based on financial & text info | Excel Discussion (Misc queries) | |||
create an excel formula with contitions | Excel Worksheet Functions | |||
Can I create a form to run off of info saved on Excel 97? | Charts and Charting in Excel | |||
Create an if-then formula in Excel to limit column total? | Excel Discussion (Misc queries) |