Calculating info from worksheet

**kathi** · 04-11-2007, 10:16 AM

Ok I hope I can explain this.

What I need is that as the hours are added in the top of the form they calculate to the bottom of the form under matching type. And I also need if they say yes under Range that I need it to go under Range and if it is yes under contractor I need it to go under that. I only want to have yes or no in that one spot not in the whole column.

So in the end that is what I would like to see...

Under Contractor I would like the 5 hours of Staging 5 hours of Concrete
(hours are under Dustin)

then under Range it would be 29 hours of welding.

Thanks

Kathi

**VBA Noob** · 04-11-2007, 01:53 PM

Hi,

Your example is not very clear.

This may get you started

=SUMPRODUCT(--($C$7:$C$30=C34)*($D$7:$D$30="No")*($B$7:$B$30))

VBA Noob

**kathi** · 04-11-2007, 03:05 PM

Ok - I have attached a new form. and I will try and expain again.

As you can see there are three emplyoees (Dustin, Jeremiah and Mike)

They have worked some hours and they are entered in that day and what it was they were working one. We have 2 types of emloyees Range and Contractor. and what I need this sheet to do is add up in the D34 to D44 (for Range emplyoees) to add up the hours I have listed in E34-44 then in colunm H34 to H44 (Contractors) I have listed what I need to total hours to add up as I have listed in green on I34-44. To find out what type of employee it is listed on line 6 and 7 that will be the only place that it is listed.

Let me know if you have more questions and I will try and explain.

Kathi

**VBA Noob** · 04-11-2007, 03:08 PM

The attachment appears to be corrupt. While don't you just post an excel file.

Just winzip it

VBA Noob

**kathi** · 04-11-2007, 03:25 PM

Let me know if this worked!

Kathi

**VBA Noob** · 04-11-2007, 03:44 PM

Try

=SUMPRODUCT(--($C$7:$C$30=C34)*($D$7="Yes")*($F$7:$F$30))+SUMPRODUCT(--(($K$7:$K$30=C34)*($H$7="Yes")*($J$7:$J$30)))+SUMPRODUCT(--($G$7:$G$30=C34)*($L$7="Yes")*($F$7:$F$30))

and

=SUMPRODUCT(--($C$7:$C$30=C34)*($E$7="Yes")*($B$7:$B$30))+SUMPRODUCT(--(($K$7:$K$30=C34)*($I$7="Yes")*($J$7:$J$30)))+SUMPRODUCT(--($G$7:$G$30=C34)*($M$7="Yes")*($F$7:$F$30))

VBA Noob