Sum If question

  • Thread starter Thread starter Graham
  • Start date Start date
G

Graham

I have a summary page on a sheet that i want to use to
count entries on a details page.

I want to use the sum if ( i think )- scenario is
column a date , column b person , column c method.

I would like to have a summary that reads
Sum if - column B = Graham , Column C = email , Column C
= some time in last week.

Equall I would like to do the same to capture same datat
but for anything prior to last week.

Hope i make sense !!!
 
Hi Graham

you'll actually need the sumproduct function

for last week
=SUMPRODUCT((A2:A8="Graham")*(B2:B8="Email")*(C2:C8>=NOW()-7))

for previous weeks
=SUMPRODUCT((A2:A8="Graham")*(B2:B8="Email")*(C2:C8<NOW()-7))

Cheers
JulieD
 
Be careful using NOW, it includes the hh:mm:ss as well. You might be needing
TODAY()

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top