- Joined
- Oct 12, 2010
- Messages
- 2
- Reaction score
- 0
First of all thank you for any effort put in this direction. I am having problems with a couple excel formulas that I really need to get right for a client.
Here is the deal:
WORKSHEET 1
Column1 = email address
Column2 = ***This column I want the sum of events on new years but having problems (Stuck)****
WORKSHEET 2
Column1 = email address
Column2 = if an event is on new years indicated with a 1 if it is on new years and blank if it is not.
I guess where I am confused is I do not know if it is best to do the summing in a column3 of WORKSHEET 2 and then use a Vlookup to pull that data into Column2 of WORKSHEET 1. OR if the summing should happen in the same formula as the vlookup??
Any help with this is most appreciated!
One thousand thank you's!
-Michael
Here is the deal:
WORKSHEET 1
Column1 = email address
Column2 = ***This column I want the sum of events on new years but having problems (Stuck)****
WORKSHEET 2
Column1 = email address
Column2 = if an event is on new years indicated with a 1 if it is on new years and blank if it is not.
I guess where I am confused is I do not know if it is best to do the summing in a column3 of WORKSHEET 2 and then use a Vlookup to pull that data into Column2 of WORKSHEET 1. OR if the summing should happen in the same formula as the vlookup??
Any help with this is most appreciated!
One thousand thank you's!
-Michael