adding

HI I am basically using this below to add 2 cells together. I need to change it to work If in Cell K there is nothing then return zero or blank. If there is a umber in K. Then it would work like shown adding both up. I am trying not to add AH if K is empty. Thanks =SUM(K23,AH23)

Hi All, I have the below formula, and the coloured words are name boxes. What I try to achive here is to have a shorter formula which pulls the info from those ranges, instead of adding each column to the formula. = IF(U5=HighestRatesTech,580, IF(U5=MidHighRatesTech,475, IF(U5=Z19,370...

Hi All I did try a search and couldn't easily see that this has been asked already, so here goes... Has anyone tried adding query parameters to a url using FollowHyperlink, and getting a True or False return value depending if the PHP Get script on the page using the parameter validates or...

Split numbers in 7 positions and make all possible sets adding 0 in it</SPAN></SPAN> Hello,</SPAN></SPAN> I need to produce all possible set adding 0 in to given numbers (spiting in to 7 positions)</SPAN></SPAN> Which finally sum should be = 7 for each of lines</SPAN></SPAN> Here are the...

=SUMIFS('GJS2'!$C:$C,'GJS2'!$A:$A,GJNETS!$A8) I need to be able to add 0999 client separate from 999 client and it's adding them together. Iv'e for mated it as text and tried putting the whole code in a SUMPRODUCT.

When adding the Hours Worked for each it is not calculating properly, 12:00 + 10:00 + 10:00 + 12:00 is adding up as 22:00 instead of 44:00. Can anyone help with this? Shazz x

I need your help adding a third scenario to this countifs formula: =COUNTIFS(Details!C:C,"Out of Compliance Contracts", Details!A:A,IF($C$5="Grand Total","?*",$C$5)) Need to add also if D:D,"CURRENT MONTH"

I’m constructing an inventory file that’s ODBC linked. Said file will be handed off to a clerical assistant when finished. Can a user form be added to edit the query when adding client numbers, or will the user have to edit the actual sql script? If so, are there any tutorials that any of you...

I have a excel work sheet that I exported. in column "D" i have cost codes. for example 00-105, 00-600. some of them do not have a dash. for example 01600, 05300. What would be the fasted was in adding a "-" when missing?

Hi I have below many more of these I added to this, but it wont let me add anymore +SUMIFS. I tried to go to second line using , _ but nothing. How can I keep adding if I need to go to second line rather then keep going across ? FormulaR1C1 =...

Hi I have a shape that I use as a button that displays a msgbox when clicked.When I add a screentip to the shape (by adding link to the shape), the code is not executed (MsgBox is not displayed). Instead, I got this error.. Cannot open the specified file. Is there a way to add a screentip to my...

Adding blank rows in a Multi level data sort. I need 7 blank rows in between the sorted data. I am sorting by two different variables. Can anyone write a VBA? I can also supply the data if needed. thank You, Jeff

I need to change a lot of hyperlinks in a spreadsheet, as users where saving to their shared drive instead of a central location. I have this code, which is nearly working... Public Sub ChangeHyperlinks() Dim ws As Worksheet Dim hlink As Hyperlink Dim p As Long For Each ws In...

Hi, Atm i have this code .to = sh.Range("b2").Value and would like to add the excel fomula -> =proper(b2) I don't know how to intigrate this together, so any help would be great and some explenation would be appriciated as well. Kind regards, Les

Hi My original formula in column H =SUMIFS($B$2:$B$10000,$A$2:$A$10000,G2,$C$2:$C$10000,H$1) I got it faster by editing as below: =IF(G2=0,0,SUMIFS($B$2:$B$10000,$A$2:$A$10000,G2,$C$2:$C$10000,H$1)) Wondering if adding a COUNTIF check would make any difference? Like...

Hey everyone, I'm wondering unless I've overlooked it can you change the color of the cells without adding a background picture on Excel?

I have 6 dates in a medium dare format and am trying to count the number of dates in September by using month = 9 and then adding it to if they gave been paid “No. Was thinking of doing some code below =if(month($A$2:$A$7)=9”,1,0) However am getting a value error Anyone got any ideas

Hi there excel gurus How do I write a formula for an invoice that will calculate the following mileage: mileage up to <=200km the rate is .50c, remaining mileage >200km rate is .35c - the formula will be in one cell looking at the quantity in the next cell. So for anything over 200km the...

Hello people Just been having a Google re adding text and a formula to a shape and found nothing that suggests that this is possible. But I'm sure I saw a video on just this thing a few months back. Annoyingly I cant find that video now - so maybe it was a dream. If someone could confirm if...

Hello, I am working on adding a vertical line to indicate today() in my bar chart in which the X- Axis is configured only in months. Is it possible to do this? If not please suggest some methods to draw a verical line on today's date in the bar chart. am using Excel version 2013 thank you