Adding based on a criteria.

  • Thread starter Richard - ExcelForums.com
  • Start date
R

Richard - ExcelForums.com

Hello

If i have

A
1 12:00
2 08:05

how would I add up the amount in columb B depending on what the tim
in columb A was

i.e. between 08:00 and 08:15 etc

I've got a feeling it can be used by doign SUMPRODUCT() but cant ge
it to work as I keep getting formula errors

Cheers in advance
Richar
 
B

Bob Phillips

Hi Richard,

Try

=SUMPRODUCT(--(A1:A100>=TIME(8,0,0)),--(A1:A100<=TIME(8,15,0)),B1:B100)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return column values based on criteria (HLOOKUP & VLOOKUP?) 0
Sumproduct Help! 3
count on 3 criteria 3
Sum the difference between dates given a certain criteria 5
Calculating the difference between two dates if two criteria are m 3
A function for filtering between Dates 4
IF calculation of Time 2
Calculate the duration between the end time and start time of anot 4

Top