Question_sumif_countif_multiple ranges

**Konexcelmath** · 08-29-2013, 12:16 PM

Hello again VBA experts I want your help.

I have written done a code that produce a form. I you will see in the attach file I have tried through an input box to add as many form I want and they are created as simply copy – paste.

But the problem comes up with the formulas. As you will see I have some countifs and sumif’s to add and count the columns.

The problem is that when I make the multiple copy– paste of form, I cannot keep the formulas working. So here I need your special help.

The concept is the following

The array is from A1: I26.

The row 1 & 2 at columns A:I are the headers and at Rows C23:H23, C24:H24, C25:H25 I make the sum of the columns C-H rows 3-22.

But, if in column “I” I have the remark “aa” the sum of this row goes at C24:H24 and if I have “bb” the some goes at C25:H25, and these two sums (C24:H24, C25:H25 are deducted from C23:H23.

Also at B23 it counts how many names from e3:e22 is having a value >1. At B24 it counts how many names from e3:e22 is having a value >1 and remark “aa” at I3:I22 and at B25 it counts how many names from e3:e22 is having a value >1 and remark “bb” at I3:I22 and these two counts (B24, B25) are deducted from B23.

Also Autofill at range A3:A22 doesn’t work!!!!

Please for your help. Thanks a lot.