M
Michelle
I have a spreadsheet with 31 tabs. In column A of each
tab are a list of names in no particular order and in
column B are dollar amounts associated with each name. (I
do not have the option of sorting the names so that they
appear in the same order every day because the same names
do not appear each day).
I am attempted to create a Month to Date sheet that sums
the total dollar amount for each person by name for the
month. I thought a sumif formula might work, however, I
receive a #value error each time I attempt to create one.
Any help would be appreciated.
tab are a list of names in no particular order and in
column B are dollar amounts associated with each name. (I
do not have the option of sorting the names so that they
appear in the same order every day because the same names
do not appear each day).
I am attempted to create a Month to Date sheet that sums
the total dollar amount for each person by name for the
month. I thought a sumif formula might work, however, I
receive a #value error each time I attempt to create one.
Any help would be appreciated.