| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum or Countif over Multiple Columns
Hi
Currently I am using Sumproduct to count column B "NU" and column F "D" but now I also need it to look at column I (which contains the value for that row) and then calculate that figure. e.g. using the Sumproduct column B "NU" and column F "D" there are 34 entries so it should calculated each entry (expected value of £45,000). Can anyone solve this problem for me????? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linking multiple columns onto multiple worksheets | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Using Countif on multiple columns | Excel Worksheet Functions | |||
| Filtering Text Data from Multiple columns | Excel Worksheet Functions | |||
Threaded Mode
