Sumproduct formula to count  total duration

Theva
Theva used Ask the Experts™
on
Hi,

I need Experts help. How to create “ sumproduct “  formula to count total duration (Column_F; Copy sheet) of Backup A and Backup B in data sheet based on name (column_A ) and Status (column_C) in Copy sheet. I’ve manully type few sample in Data sheet for Experts to get better view.



Copy-and-Paste-.xlsm
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Top Expert 2011
Commented:
In B3 enter:
=SUMPRODUCT(--(Copy!$B$2:$B$18=$A3),--(Copy!$C$2:$C$18=B$2),Copy!$F$2:$F$18)
and copy across and down.

HTH
Rory

Author

Commented:
Hi Rorya,

Thanks a lot for the formula.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial