Here is a simplified view of a cost spreadsheet I need to create: What I need to do is keep a running total for the items listed at top as each month's reports come in. Below the running total is an imaginary report for Jan, Feb, and Mar. The problem I have is that each month's reports may have different items (see how March is missing one?) Is there a way to make the top running totals pick out a constant and add the dollar value to the running total? For example, can cell D4 pick out all the #1's found in column A and add up the corresponding dollar amounts for that line item?
Too bad my boss doesn't post here because he uses the "SUMIF" function a lot and I unfortunately do not. About as complicated as I would get with excel are VLOOKUPS and IF THEN statements. But I am pretty sure a "SUMIF" would do what you want. Maybe someone else here has used it or you can read more about it on the help section. Good luck.
Thanks Manny. I looked up SUMIF in the Excel help and was able to make it work. No more manual entries, it's all copy and paste from now on. The power of this BBS rides again!!!
Sounds like you got it, but if not =sumif(lookuprange,lookupvalue,datarange) in this case =sumif($b$9:$b$lastrow:C4:$d$9:$d$lastrow) should = $110
Yep, it works exactly like I wanted it to. But more importantly is the way anyone can get the answers they need from this BBS. I love this place!!!!
