Array Formulas

pooley

New Member
Joined
Jul 17, 2006
Messages
17
I have a data sheet with a series of dates in the first column, error types in the next column and minutes taken to resolve the error in the last.
I want to get a total of time taken for each error type for any given date, can I use an array formula to do this and if so can somebody give me a headstart as to how as I am getting nowhere fast.

Date: error type: minutes taken to resolve

want end up selecting a date and a error type and having a total time lost for that error on that date.
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Here is a normal (non-array) formula:

=SUMPRODUCT(--(A2:A10=DATEVALUE("11/10/2006")),--(B2:B10=1),C2:C10)

Adjust the ranges to suit, but they must all have the same number of rows and can't be entire columns. You can use cell references for the tests DATEVALUE("11/10/2006") and 1.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,042
Messages
5,545,688
Members
410,698
Latest member
Wloven
Top