Hi,
I was hoping somebody could help me with a formula I have set up. Currently, the formula is a SUMIF formula which looks for criteria in a particular cell.
=SUMIF(TABLE1,C1, TABLE1[Category])
I may have written this out wrong but I hope you understand what I mean. Currently C1 is a list with different names, if I choose a name then the formula will give me the correct result for that. I was wondering whether it was possible to choose more than one item, like category may be A or B. I understand I can do this by adding a second criteria to the end of the formula but this type of formula will be repeated many times on the same sheet and I would prefer not having to change the structure by adding or removing a criteria. There will be cases where I will want to check only one category and others maybe quite a few.
Any help is much appreciated.
Many thanks
Bookmarks