HI GUYS! PLEASE HELP!
As per attachment, I want to sum per month using a excel formula.
for example:
1. sum if all date is equal to APRIL
THANKS IN ADVANCE![]()
HI GUYS! PLEASE HELP!
As per attachment, I want to sum per month using a excel formula.
for example:
1. sum if all date is equal to APRIL
THANKS IN ADVANCE![]()
May it works:
=SUMPRODUCT((MONTH($B$2:$N$2)=4)*$C$2:$O$2)
Quang PT
this are my data:
30-Oct-13 10,000.00 21-Nov-13 8,500.00 21-Dec-13 8,500.00 21-Jan-14 8,500.00 00-Jan-00 - 00-Jan-00 - 00-Jan-00 - 00-Jan-00 - 00-Jan-00 - 00-Jan-00 - 00-Jan-00 - 00-Jan-00 -
if the data are place in B2, using your formula, the value is 83,289.00, but it should be zero.
Thank you Sir bebo021999. It works in the file that I attached but not in my actual excel file.
this is my formula:
=SUMPRODUCT((MONTH(CR140:DP140)=4)*CS140:DQ140)
even though the dates are not 4, it has amount.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks