Solved

# Need help with sumifs in 2003

Posted on 2011-03-22
264 Views
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
Question by:bvanscoy678
• 2

LVL 81

Accepted Solution

zorvek (Kevin Jones) earned 250 total points
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

broomee9 earned 250 total points

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

LVL 24

Expert Comment

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

I split it because of the help with Absolute Reference!

Thanks
0

## Featured Post

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

#### Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!