rewrite

Hello: I have the following formula =INDEX(CCMSTime!C:C,MATCH(A2,CCMSTime!A:A,0)) Works great, except when there is nothing to return I get the following #N/A, which causes problems when I am trying to do SUM How can I rewrite my formula so that if there is nothing to return Excel places a 0...

Hi Is their a way to rewrite these 2 sumifs (array) into 1 so that I would have 4 conditions? =SUM(IF(($H$2:$H$2634<$N3)*($H$2:$H$2634>=N4),$G$2:$G$2634,"")) =SUM(IF(($A$2:$A$2634<$O3)*($A$2:$A$2634>=O4),$G$2:$G$2634,"")) Thank you! MM

I have this code in my “Thusworkbook” Sub COPY() Sheets("Legend").Range("R4").COPY Sheets("Bid Calculator").Range("C29") With Sheets("Bid Calculator") For MY_COUNT = 3 To 7 If Not (IsEmpty(.Cells(29, MY_COUNT).Value)) Then A =...

Hi all, I was given the following formula by one of you guys on here (Thanks so much) It works apart from the fact I would like it to look down the two columns and match the specific text then do the remainder of the formula rather than be assigned specifically to each row ('PMI Schedule...

Hi I am currently copying information from a different source into Excel. The source gives me values which i want to rewrite. An example would be that the source gives me a value in column M that is "1". But i need to rewrite that information into "Completed". This is now done manually but i...