Solved

Need help with sumifs in 2003

Posted on 2011-03-22
4
267 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

828 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