| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding up sums only if condition is met
Here's an example of a spread sheet:
A B 1 1 $55.25 2 $997.00 3 $693.36 4 1 $535.00 5 1 $325.12 6 $636.36 7 1 $1009.00 can someone help me with an function to help me add up the total of coloumn B only if coloumn A has a "1" I tried this: =SUMPRODUCT(--(Sheet1!A1:A7="1"),Sheet1!B1:B7) and it wasn't working, i think this is close though |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding sums in rows and columns and colouring cells with condition | Excel Discussion (Misc queries) | |||
| Formula for adding sums | Excel Worksheet Functions | |||
| Adding sums from different worksheets | Excel Worksheet Functions | |||
| Finding a value by adding certain sums in a range? | Excel Discussion (Misc queries) | |||
| Adding up Sums | Excel Worksheet Functions | |||
Threaded Mode
