I have a previous 6 month total of variances (Variances: Column G). A few dates have several variances (Dates: Column B).
In (column J) I have a dates and (Column K) is where I want to gather the total variances (From column G) from the Dates in (Column B)
Wow that is hard to explain, but I attached a sample.
Basically I need help with a formula in K3 on down.
Thanks for any help,
Nick
Last edited by avidcat; 05-24-2013 at 01:22 PM.
Nick in K2 and copy down.
=SUMIF($B$2:$B$1000,J3,$G$2:$G$1000) ???
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
That works perfect, thanks!
You are welcome. Thanks for the reb*
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks