View Single Post
  #19   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Count the sum of multiply values in one cell, registered as part of a textcode, combine them per column and show the results in the next sheet

Hi Johan,

Am Sat, 1 Jun 2019 23:00:46 -0700 (PDT) schrieb JS SL:

Sheet.3; For Mister.X the value 50 is registered and for Mister.Y 100


In sheet.2 in column.J (perhaps you can give it the RangeName 'cost' so it can flow when inserting/deleting columns), I like to have the sum of the values for each column in the same row.

What you get is; Mister.X = value 10 - multiply with 50 from sheet.3 = 500. In the same record stands Mister.Y = value 6 - multiply with the value 100 in sheet.3 = 600.

This gives the sum of 500+600=1100. This should be then the value in column.J of that record in sheet.2.

If..... the name in sheet.2 isn't exist in sheet.3 column.B then, if there is a value registered in sheet.2, the cell should be marked red.

Another exception.... this count rule must only count if the last 2 digits of that record in sheet.2 column.M (thats the famous 'codes' RangeName) is "HR".


that is easier and faster when you do it with formulas and conditional
formatting.


Regards
Claus B.
--
Windows10
Office 2016