Using variables in formulas/ranges

aren't you going to want this to be dynamic so you can make it work for jan, feb...dec? or do you only want to sum net incom (loss) for january?

it is best to post a sample workbook, but take out any sensitive info and replace it with dummy data, hit the go advanced button and click the paperclip to attach a file

try something like the following which asks the user to input the month to be summed with an input box, then uses the search function to search for the appropriate month and sums the Net Income (Loss)

here's a copy of the workbook with the macro and a form button to run it NIL example.xlsm

HTML Code: