Hello,
I am trying to itemize expenses by division of operations for my farm. I have a list of every expense made throughout the year. I need it summarized but flexible enough to account for differently named items that may be purchased in the future.
Per my image uploaded:
I am looking to create separate summaries per the divisions in column F (chicken, Goat, LGD, etc) for the total annual expense for items in column E. So, I am looking for a formula for M3 that will return items listed in column E only if column F contains "chicken." But, the formula must allow for a new item to automatically be included that differs from a previous entry.
First, I have used the formula =INDEX($G$3:$G$203,MATCH(0,COUNTIF($M$2:M2,$G$3:$G$203),0)) in cell M3. When copied down column M, it fills in each unique entry in column E exactly as I would like except, I need to exclude any entry in column E that does not have "Chicken" entered on the same row in column F. What do I need to change/add?
I have a working knowledge of Excel but I am not an expert by any means. Please be clear and concise and if possible, provide the complete formula for visual reference.
Thank you.
I am trying to itemize expenses by division of operations for my farm. I have a list of every expense made throughout the year. I need it summarized but flexible enough to account for differently named items that may be purchased in the future.
Per my image uploaded:
I am looking to create separate summaries per the divisions in column F (chicken, Goat, LGD, etc) for the total annual expense for items in column E. So, I am looking for a formula for M3 that will return items listed in column E only if column F contains "chicken." But, the formula must allow for a new item to automatically be included that differs from a previous entry.
First, I have used the formula =INDEX($G$3:$G$203,MATCH(0,COUNTIF($M$2:M2,$G$3:$G$203),0)) in cell M3. When copied down column M, it fills in each unique entry in column E exactly as I would like except, I need to exclude any entry in column E that does not have "Chicken" entered on the same row in column F. What do I need to change/add?
I have a working knowledge of Excel but I am not an expert by any means. Please be clear and concise and if possible, provide the complete formula for visual reference.
Thank you.
