Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 273
  • Last Modified:

Need help with sumifs in 2003

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
bvanscoy678
Asked:
bvanscoy678
  • 2
2 Solutions
 
zorvek (Kevin Jones)ConsultantCommented:
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
 
TracyVBA DeveloperCommented:
Use SUMPRODUCT instead:

=SUMPRODUCT(($A$13:$A$40=$P6)*($D$13:$D$40=R$4)*($I$13:$I$40))
expert-exchange.xlsx
0
 
TracyVBA DeveloperCommented:
Beat me to it! :-D

Except you probably don't want an absolute reference on the column for R4.  Should be R$4.
0
 
bvanscoy678Author Commented:
I split it because of the help with Absolute Reference!

Thanks
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now