Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / May 2008

Tip: Looking for answers? Try searching our database.

Conditional Summing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RichieK - 12 May 2008 19:24 GMT
Hello
I have a summing question.  I want to, by day, sum the values in the 4th and
5th rows respectively based on the Machine #.
For example: for the 28th the sum for 179 would be 85 Actual, the sum for
216 would be 271 Actual etc.
Is this possible with the data laid out as below?
Thank you very much in advance
Rich K

Date    Machinist    Machine #    Actual     Hrs. Worked
28-Apr-08    Kifle    179    85    7.50
    Cathy    216    95    7.50
    Nor    216    88    7.50
    Kifle    216    88    7.50
    Dan    205    99    7.50
               
29-Apr-08    Kifle    216    87    7.50
    Cathy    216    85    7.50
               
               
               
               
30-Apr-08    Kifle    216    91    7.50
    Cathy    216    83    7.50
               
               
               
               
1-May-08    Kifle    216    85    7.50
    Cathy    216    83    7.50
               
               
               
               
2-May-08    Kifle    216    92    7.50
    Cathy    216    83    7.50
Sandy Mann - 12 May 2008 20:58 GMT
It would simplify your problem greatly if you had the date in *every* Row
with data in it.  You could then use SUMPRODUCT():

=SUMPRODUCT((A2:A8=DATE(2008,4,28))*(C2:C8=216)*D2:D8)

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> Hello
> I have a summing question.  I want to, by day, sum the values in the 4th
[quoted text clipped - 24 lines]
> 2-May-08 Kifle 216 92 7.50
> Cathy 216 83 7.50
RichieK - 14 May 2008 15:21 GMT
Hi Sandy
Right after I posted I solved the problem simply using SumIf

> It would simplify your problem greatly if you had the date in *every* Row
> with data in it.  You could then use SUMPRODUCT():
[quoted text clipped - 29 lines]
> > 2-May-08 Kifle 216 92 7.50
> > Cathy 216 83 7.50
Sandy Mann - 15 May 2008 00:27 GMT
As long as you found an answer - that is the important thing

Signature

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> Hi Sandy
> Right after I posted I solved the problem simply using SumIf
[quoted text clipped - 34 lines]
>> > 2-May-08 Kifle 216 92 7.50
>> > Cathy 216 83 7.50
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.