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?
=SUMPRODUCT(--(E1:E100=4),D1:D100)
or =SUMIF(E1:E100,4,D1:D100) "Valerie" wrote: I would like to create a function to add the money in the "amount" column for each specified number in the "Priority" column.. For example, all "PRIORITY", 4, would calculate the sum of it's "AMOUNT" counterparts. If Amount what Column D and Priority was column E.(D18+D19+D20+D21+D22+D23) My "LOOKUP" reference isn't doing it and neither is my "IFSUM". Can you please help me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create two columns from one column (space separated info | Excel Worksheet Functions | |||
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 |