View Full Version : Solved: Date format problem
justdriving
09-20-2011, 02:28 PM
Hi,
In attached Sheet, I am requesting a VBA code which can calculate Col R to Z without having any formatting problem with Date2 mentioned in H Col and R3, W3. I think there was formatting problem because of which Col X to Z were not calculated.
Bob Phillips
09-20-2011, 02:48 PM
Try
=SUMPRODUCT(--($A$2:$A$151=$R4),--($E$2:$E$151="S"&COLUMN(A$1)),--($H$2:$H$151=$R$3))
and
=SUMPRODUCT(--($A$2:$A$151=$W4),--($E$2:$E$151="S"&COLUMN(A$1)),--(TEXT($H$2:$H$151,"mmmm")=$W$3))
justdriving
09-21-2011, 03:28 AM
Try
=SUMPRODUCT(--($A$2:$A$151=$R4),--($E$2:$E$151="S"&COLUMN(A$1)),--($H$2:$H$151=$R$3))
and
=SUMPRODUCT(--($A$2:$A$151=$W4),--($E$2:$E$151="S"&COLUMN(A$1)),--(TEXT($H$2:$H$151,"mmmm")=$W$3))
Hi Bob,
Thanks. I request you to please convert above program in VBA using Range notation or Cells() notation. It will help me. My excel worksheet does not recognize Dates.
justdriving
09-21-2011, 12:33 PM
Hey Bob,
Please don't mind my signature. I was so happy that I wrote that. Anyway, I solved this problem by recording macro. It worked.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.