Forum Discussion
KAM_Mumin
Oct 22, 2022Brass Contributor
MS EXCEL VBA IF Formula.
Hi Everyone! I have a stock sheet with all models which I have already and now want to get some spcific models stock in a new sheet,,, I use =SUMPRODUCT(([@[Model No]]=RefModelsT[Model No])*RefMode...
- Oct 22, 2022
Do you want to sum in VBA only with IF THEN ELSE END IF statement without using a standard sum formula (SUMIF, SUMIFS, SUMPRODUCT)? If so i can't help you unfortunately.
KAM_Mumin
Oct 22, 2022Brass Contributor
Bro yours is ok,,, but I want to do it by VBA IF function,,,if you can then Please
OliverScheurich
Oct 22, 2022Gold Contributor
Do you want to sum in VBA only with IF THEN ELSE END IF statement without using a standard sum formula (SUMIF, SUMIFS, SUMPRODUCT)? If so i can't help you unfortunately.