SUMIF in VBA

[bhanu2003]

Hi,

tried searching to see if i could avoid the post but, sorry could not find, so posting.

i want a variable to have the value of a sumif condition.

That is, say

SUMACT = SUMIF(E28:I28,"",E27:I27)

Thanks,
Bhanu

 

[Ekim]

Bhanu,

Using your data, I get 260 (as required by you) with each of the 3 macros presented. The macros works irrespective of whether the data in E27:I27 and E28:I28 is determined by a formula or result from manual input.

The following was setup to test whether the macros are effected if the data is determined by a formula:

Sumif - VBA.xls
	C	D	E	F	G	H	I
20
21	Input:				20	193	67
22			65	76	80
23
24
25
26
27	Output:				20	193	67
28			65	76	80
29
30
Sheet1

E27:
=IF(E21<>"",E21,"")
Copied to I27

E28:
=IF(E22<>"",E22,"")
Copied to I28

I still get 260 (the sum of H27 and I27).

Two things to check:
1. Are you putting the macros into a standard module?
2. Do cells H28 and I28 really have no value? e.g. the cells may have conditional formatting or custom formatting that makes them appear as blank. A zero in a cell, custom formatted as a blank, is not “no value” as far as the macro is concerned. Also, check under the Tools menu | Options | View tab – ensure that the check box for “Zero values” is checked.

Regards,

Mike

 

[shanky1]

Hi Bhanu,

Iam a newB in this but wanted to see if this could also be a possibility, likein do we save the sheet as .xlsm to save a macro????

 

[nchittim]

Private Sub FindTotal()
With Sheets("DT Week 1")
Sheets("SEPTEMBER").Range("L5:L23").Value = _
WorksheetFunction.SumIfs(.Range("B:B"), _
_
.Range("G:G"), "=Fasiuddin Md" & .Range("L5").Value)
End With
End Sub
I am trying this in VBA but returning "0",Please help on this,I am very new to VBA.
I have names and time in DT week 1(sheet name) and result should be appear in SEPTEMBER(Sheet name)
Any help is appreciated,

Thanks in advance,
Ch Nagaraju