Prev: Linking Equations to Highlights
Next: View Message when Mouse Hovers over Cell. (Not the Comments Feild)
From: Max on 30 May 2010 21:52
well, if you want to use SUMIF to get the sum of col B for dates in col A in
Apr 2010, this seems to work fine:
=SUMIF(A:A,">="&--"1 Apr 2010",B:B)-SUMIF(A:A,">="&--"1 May 2010",B:B)
Care should be taken to be unambiguous when dealing with dates
--
Max
Singapore
---
"KDenise" wrote:
> I need some assistance with tracking my commissions that are due to be paid
> each month. The "Comm Due Date" is in column "C", rows 3 - 30 which list by
> date all of the Commissions Due to be paid and the "Comm Balance" is in
> column "H", rows 3 - 30 which has the Commission Balance due for each sale.
> I tried utilizing a formula from a post that I found from April '05 but for
> some reason I keep receiving a #NAME? error. I'm not sure what I am doing
> wrong. I want to find the total due by month so that as I add additional
> sales to the spreadsheet it will update the total due for each month. Can
> anyone please help me?
>
> =SUMIF(Comm_Due_Date,">=04/01/2010",Comm_Balance)+SUMIF(Comm_Due_Date,"<=04/30/2010",Comm_Balance)
>
> If you need additional information, please let me know.
> KDenise
From: Max on 30 May 2010 23:47
Note the careful avoidance of having to specify the last day of the month
(the "ugh" moment) in the earlier SUMIF expression <g>
--
Max
Singapore
---
First  |  Prev  | 
Pages: 1 2
Prev: Linking Equations to Highlights
Next: View Message when Mouse Hovers over Cell. (Not the Comments Feild)