Sum Count Ifs

[Wildcats23]

Hello,

How do you write a macro that has an entire range of D3:AD29 equal to the following formula =sum(countifs(range,criteria,range2,criteria2),countifs(range,criteria,range2,criteria2))?? THANK YOU!!!

 

[orsm6]

enter formula to every cell D3:AD3


then run code from module

Sub copydown()
LastRow = Cells(Cells.Rows.Count, "A").End(xlUp).Row
    Range("D3:AD29").FillDown
End Sub

Hello,

How do you write a macro that has an entire range of D3:AD29 equal to the following formula =sum(countifs(range,criteria,range2,criteria2),countifs(range,criteria,range2,criteria2))?? THANK YOU!!!

 

[orsm6]

take out the last row... not needed.

Sub copydown()


    Range("D3:AD29").FillDown
End Sub

 

[Wildcats23]

Thank you for your reply, I should have been more specific. Each cell has a different criteria...before I send you running, Let me clarify. each cell in using the column header and current row it is in. As an example here is what the formula looks like =sum(countifs(fixed,Column header "d2",fixed,row reference "a3"),Countifs(fixed, column header "d2", fixed, row reference "a3"). How do I write a macro so It is running in the background and only shows the cell values in the cell when I click a cell in the D3:D29 range?

 

[Peter_SSs]

Question begun again here.

In future, please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.