sum with 2 criteria
 

I have an excell sheet that gets updated daily with submissions from
different departments, what i want to do is to use a formula to submission by
the department and between two dates

One way

=SUMPRODUCT(--(A2:A50="Department"),--(B2:B50=D2),--(B2:B50<=E2),C2:C50)

where D2 hold the start date, E2 the end date and C2:C50 the amount/values
to sum

--
Regards,

Peo Sjoblom

(No private emails please)


"Dave" wrote in message
...
I have an excell sheet that gets updated daily with submissions from
different departments, what i want to do is to use a formula to submission
by
the department and between two dates

Hi,

You can also try using array formulas (Ctrl+Shift+Enter)

=count(if((range1="department")*(range2<date1)*(ra nge3date2)),1,0))

Regards,

Ashish Mathur

"Dave" wrote:

I have an excell sheet that gets updated daily with submissions from
different departments, what i want to do is to use a formula to submission by
the department and between two dates