Solved

Need help with sumifs in 2003

Posted on 2011-03-22
4
266 Views
Last Modified: 2012-05-11
I thought this was completed, but I built this at home in excel 2010. But, work only has 2003, so I just figured out my =sumifs won't work.

Any suggestions on how to collect my data without using =sumifs.

Right now, I have my pivot collecting my dates and then use =sumifs to collect the time.

thanks for any help
expert-exchange.xlsx
0
Comment
Question by:bvanscoy678
  • 2
4 Comments
 
LVL 81

Accepted Solution

by:
zorvek (Kevin Jones) earned 250 total points
ID: 35192542
Use this formula in R6 and copy as needed:

=SUMPRODUCT($I$13:$I$40*($A$13:$A$40=$P6)*($D$13:$D$40=$R$4))

Kevin
0
 
LVL 24

Assisted Solution

by:broomee9
broomee9 earned 250 total points
ID: 35192560
Use SUMPRODUCT instead:

=SUMPRODUCT(($A$13:$A$40=$P6)*($D$13:$D$40=R$4)*($I$13:$I$40))
expert-exchange.xlsx
0
 
LVL 24

Expert Comment

by:broomee9
ID: 35192570
Beat me to it! :-D

Except you probably don't want an absolute reference on the column for R4.  Should be R$4.
0
 

Author Closing Comment

by:bvanscoy678
ID: 35192616
I split it because of the help with Absolute Reference!

Thanks
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question