multiply criteria

Hello Everyone! I ran into an issue with macros and I could use some guidance! I attach a sample excel file for ease of reference. I need to write a VBA code which needs to: 1) Check if a condition is met ("Other" or "Building") -> Column D If "Other", then multiply OMV (Column C) x 0.30% If...

i am trying to use the product equation to product some values from certain date rang, i was thinking maybe there is some-sort of productif equation or so. thanks in advance

Hey, In Col. A, I have ID numbers and in Col.B I have figures. I want to multiply Col. B if my criteria fits in Col. A. <tbody> A B 1 2,00 2 2,50 2 1,80 2 2,5 </tbody> So the result should be : Criteria : 2 Result : 2,50*1,80*2,5 = 11,25 Thnx a lot guys.

Hello, I have this data for example. In column A I have country names in column B key words: <tbody> Country Key words Lithuania tableware; cutlery; pan;pot Germany bag; backpack; pan Germany pan; pot; backpack Estonia bag; backpack; France cutlery France pan; pot; backpack...

Hi there I have dabbled a bit with VBA in excel but im not an expert, I have designed a form with the following: From, Destination, Product, Quantity, Carton Quantity, Costing road, Costing Air I have been able to link the combobox's to the cells on the worksheet (data). 1. Need to calculate...

Good Afternoon, I am using a Mac Pro, with Excel for Mac 2011, and I am having a problem trying to multiply a certain set of values followed by an exact letter. To be more in-depth I have varied numbers followed by a letter at certain character places and what I was wanting Excel to do was get...

Hi! Here's what i want to do explained in steps: Step 1 if we are at the day of 2011-05-02 (just for example), I want to average the last 15 historical sale-values that occured at a Monday in year 2011 after 2011-05-02. Step 2 Then I want to average the 15 sale-values for the same days (here I...