| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count the sum of multiply values in one cell, registered as partof a textcode, combine them per column and show the results in the next sheet
Claus,
The way you suggest with the formula; =IF(RIGHT(M2,2)<"HR","",SUMIF(myNames,N$1,Cost)*N 2+SUMIF(myNames,O$1,Cost)*O2+SUMIF(myNames,P$1,Cos t)*P2+SUMIF(myNames,Q$1,Cost)*Q2) And NameRanges in Sheet.3 for the names and the cost, and also a ConditionalFormatting in Sheet.2, works fine. Thnk !!!. And now playing with the tool created. regards, Johan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying rows values on one sheet to part of a formula in a column | Excel Discussion (Misc queries) | |||
| Count unique values in 1 column where cells in another show non-bl | Excel Discussion (Misc queries) | |||
| Lookup values in 2 columns, count and then multiply??? HELP! | Excel Worksheet Functions | |||
| Part 2 of Show zero values only when data is..... | Excel Discussion (Misc queries) | |||
| Operations (add, multiply) on all values ($00.00) in a column? | Excel Discussion (Misc queries) | |||
Hybrid Mode
