So I've searched this forum and all over the place and can't get anything to work...If I had a better understanding of formulas (as I assume some of you do) I think this would be a pretty straight forward and common formula type. Here is the info I have:
Column A: Date
Column E: Part Number
Column H: Cost of Part
Column K: Month References
(all other columns are hidden and not needed)
Range is A2:A5000
I am trying to creat a formula to sum the totals of a given part number for a given month. In other words, I need to get my total costs for a certain part number for each month. I can't use cells as references becuase this worksheet will be used by multiple people and sorting will change, changing the reference cells.
Any help or guidance will be much appreciated!!
Here are a few of the formulas I tried but couldn't quite get to work....
{=SUM((A2:A5000="APR")*(E2:E5000="3001-01-111")*H2:H5000)}
[SUM(IF($A$2:$A$5000=$K2, IF (E$2:E$1000="JAN",D$2:D$1000),0))]
both formulas gave me zeroes when I should have had numerical results.
Bookmarks