Vlookup + Sumif OR Sumproduct!???Help!


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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top