Posted to microsoft.public.excel.misc

Stefi

external usenet poster

Posts: 2,646

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

You are welcome! Thanks for the feedback!
Stefi

€žhoyos€ ezt Ã*rta:

Thank you Stefi, that did the trick

"Stefi" wrote:

=SUMPRODUCT(--(A1:A5-1/240),A1:A5-1/24)
Regards,
Stefi

€žhoyos€ ezt Ã*rta:

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 Hybrid Mode Switch to 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 04:06 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us