Excel Formula Help Needed: lookup and calculating

  • Thread starter Thread starter charity worker
  • Start date Start date
C

charity worker

I was hoping that someone would help me with a
formula...I am maintaining and reporting on data that I
collect.

I need to breakdown this information in several ways. I
already have formulas for breaking down my information by
in-house expenditures, as well as a general outside
expenditures, however I now need to break out a specific
outside expenditure and am unsure how to do this.

The in-house expenditures are specific by number and the
outside are broken out by the following formula:
=SUMPRODUCT((NOT(ISNUMBER('2004'!$D$3:$D$3006)))*('2004'!
$H$3:$H$3006>=DATE(2004,1,1))*('2004'!$H$3:$H$3006<=DATE
(2004,3,31))*('2004'!$G$3:$G$3006=Breakdown!$Y5)*('2004'!
$E$3:$E$3006)).

My question is the following, the name of the outside
source that I now need to breakout from the general
calculations. THe specific outside expenditures I need
to breakout are marked as "MCRC". How will I need to
adopt the above formula to recognise the "MCRC" source,
keeping the formula breakdown the same (i.e. by date)?

Any help will be greatly appreciated. Thanks for
whatever help you might be able to offer in advance.
 
Hi
as posted per PM try
=SUMPRODUCT(('2004'!$D$3:$D$3006="MCRC")*('2004'!
$H$3:$H$3006>=DATE(2004,1,1))*('2004'!$H$3:$H$3006<=DATE
(2004,3,31))*('2004'!$G$3:$G$3006=Breakdown!$Y5)*('2004'!
$E$3:$E$3006)).
 
Back
Top