Thread: Count the sum of multiply values in one cell, registered as part of atextcode, combine them per column and show the results in the next sheet
View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.programming
JS SL JS SL is offline
external usenet poster
  
Posts: 49
Default 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 With QuoteReply With Quote