Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sumproduct?
Have 1000 rows of data
col A - I have Job Numbers 1 to 100 col B - I have tasks 1 to 10 col C - I have costs If I want to know the total cots of task 6 for Job 3....? I think you can do this via sumproduct? Many Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
SUMPRODUCT | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
=SUMPRODUCT | Excel Discussion (Misc queries) |