I have an excel sheet with 2 columns: Date & Amount.
I want to be able to gather the sum of all amounts together on a monthly basis.
So for instance [=sum(B:B)...only during month 9 (September) etc..]
Here´s the deal,
if you know how to do this,
place a bid and send the answer through PM and the first person to have the right answer will be awarded immediately!
Get it ASAP!
37 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
I assume, A2:A10 as dates, B2:B10 as amounts. heres the answer ... Answer "=SUM(IF(MONTH(A2:A10)=9,1,0)*B2:B10)" If the dates and amounts are longer formula is easily modifiable accordingly.