Sumproduct or SumIf?

H

Hywel

Hi all,
I am having difficulty with SUMIF or SUMPRODUCT (not sure which one to
use).
We bill clients according to the date, with one rate for before October
1st and one for after. I have a list of dates in Column B and hours
spent on that date in Column C.
How can I count the total hours before 1/10/04 and those after?
Any help appreciated
Many thanks,
Hywel
 
G

Guest

For Hours before
=SUMIF(B:B,">="&D1,C:C)

For hours after
=SUMIF(B:B,"<"&D1,C:C)

where D1 holds the date

My first formula would include the hours on your date. Eliminate the = to
remove it.

tj
 

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

Excel Sumproduct 0
sumproduct or sumif? 3
SUMIF 3
Sum with multiple conditions - sumproduct, dsum or dproduct? 3
sumproduct or sumif 1
SUMIF function formula won't work, help 6
sum multiple columns with SUMIF or SUMPRODUCT 2
SUMPRODUCT within set dates 4

Top