Posted to microsoft.public.excel.misc

Hoyos

external usenet poster

Posts: 74

SUMIF or SUMPRODUCT ?????????

Which do I use (and how) to do the following:
Add minutes only if above 1 hour.
ie
0:55
0:45
1:20
1:10
Total=4:10
Totals greater then 1:00=0:30

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need SUMIF / SUMPRODUCT help I think	Big_Tater[_2_]	Excel Discussion (Misc queries)	1	September 25th 09 12:54 AM
Sumif or sumproduct	Klee	Excel Worksheet Functions	6	July 17th 07 10:04 PM
SumIf or SumProduct	[email protected]	Excel Worksheet Functions	8	February 13th 07 06:40 PM
Sumif or Sumproduct	Steve	Excel Worksheet Functions	1	February 4th 06 08:43 PM
SUMIF or SUMPRODUCT or something else?	\|\| cypher \|\|	Excel Worksheet Functions	7	November 9th 04 10:45 PM

All times are GMT +1. The time now is 02:29 AM.

About Us

"It's about Microsoft Excel"