Hello, hopefully someone can help as i'm struggling to get this too work. I've attached an example spreadsheet and what im trying to achive is totals in cell G3 and H3, but these totals need to be the sum of amounts that are dated (in column A) the same or prior to the date in cell F1. Any help would be greatly appreciated. Thanks.
Try the below in cell G3 and drag right to H3:
Formula:
Please Login or Register to view this content.
Is that what you mean?
BSB
Hi. In G3, drag across
=SUMIF($A:$A,"<="&$F$1,B:B)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Here!
In G3
=SUMIF($A$2:$A$12,"<="&$F$1,B2:B12)
And Drag Across
Cheers!
Deep Dave
Thanks guys that seems to be what im after. thanks again
Nevermind, apparently in the time it took me to write my comments others answered your issue.
so deleted it. glad you got your help.
Last edited by Sam Capricci; 06-26-2015 at 05:07 AM.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
in GŁ: =SUMIF($A$2:$A$12,"<=" & F$1,$B2:$B12)
in H3: =SUMIF($A$2:$A$12,"<=" & $F$1,$C2:$C12)
Glad to have helped..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks