VBA Sumifs under two conditions

[Palucci]

I want to create a function that will sum me up for CRD_EKSP_PIER_DC_FIN = "CRD_EKSP_PIER_DC_FIN" CRD_KOR_DC_FIN = "CRD_KOR_DC_FIN" When two conditions are met, where DIFFRENT> 365 and CRD_RWG <1.5 However, my macro shows me a result of 0. Where do I go wrong ?

Please Login or Register  to view this content.

cross post : https://www.mrexcel.com/board/thread...tions.1194722/
https://stackoverflow.com/questions/...35586_70955630

[CheeseSandwich]

You seem to be getting a bit confused with the logic i think, the below part is counting the instances of "CRD_EKSP_PIER_DC_FIN" that are found in a column with theheader "CRD_EKSP_PIER_DC_FIN"

Please Login or Register  to view this content.

I would expect that you would use:

Please Login or Register  to view this content.

To find the cell with the correct header value and then use that cell to look in the column for something else like:

Please Login or Register  to view this content.

So - Find header column cell - Use this column - Find something in that column

Hope this helps

[Palucci]

I need to add up rCol, but when rCol1 is> 1.5 and rCol2> 365 . My code still is wrong ? still not understand

Please Login or Register  to view this content.

[kvsrinivasamurthy]

IF I understand you correctly this formula will give the required result. Pl see file.

=SUMPRODUCT(($A$2:$A$24+$A$2:$B$24)*($C$2:$C$24<1.5)*($E$2:$E$24>365))

[CheeseSandwich]

If you are following the VBA route then:

Please Login or Register  to view this content.

[Palucci]

IF I understand you correctly this formula will give the required result. Pl see file.

=SUMPRODUCT(($A$2:$A$24+$A$2:$B$24)*($C$2:$C$24<1.5)*($E$2:$E$24>365))

but how to do it in vba ?

[CheeseSandwich]

Or this may be easier to read:

Please Login or Register  to view this content.

[Palucci]

Or this may be easier to read:

Please Login or Register  to view this content.

I don't know why but it still doesn't work
crd_rwg must be greater than 1, diffrent greater than 365, and should sum the numbers in the column CRD_EKSP_PIER_DC_FIN

[CheeseSandwich]

Please Login or Register  to view this content.

[Palucci]

something wrong is in code, missing something

[CheeseSandwich]

Have a look at the attachment:

[kvsrinivasamurthy]

Macro code

Please Login or Register  to view this content.