Need help with multiple sheets sending data to one final sheet with totals

I have a TOTALS worksheet that should pull data from multiple worksheets for a total. As an example, in Column B on my master, I want it to look at each cell on all the other sheets and if Column A equals green, add the totals one place. If column A equals blue, add in another place.


Sorry I can't embed a screen shot so I'll try and demostrate it here. ( I just posted it and looked. Formating and spacing of the numbers doesn't work here so I;m not sure if what I'm explaining is clear.)



This is my TOTALS sheet which should gather data from all the other sheets.

Jan Feb Mar Apr
Green 7 12 17 15
Blue 7 15 12 21
Yellow 6 9 10 19
Purple 9 10 15 17



I will have about 30 sheets, one for each state we do business in with data like this:

This sheet is on a tab named "Alaska"
Jan Feb Mar Apr
Green 2 2 5 1
Blue 5 7 2 5
Yellow 1 3 2 9
Purple 4 4 4 3

This sheet is on a tab named "California"
Jan Feb Mar Apr
Green 2 7 9 11
Blue 0 3 4 8
Yellow 1 2 3 4
Purple 2 4 6 8


Assume that Column A on each sheet has the colors listed. I need some type of statement that says If Column A=Green, add the totals from cell data from the Alaska sheet (with an additional condition for each State)

and likewise, If Column A=Blue, add the totals from cell data from the Alaska sheet (with an additional condition for each State)

and so on.


Thanks