[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • 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

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

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