Hi!
i'm unable to understand your question may be this will help you.

If you are using excel 2007 then use sumifs.

Suppose your Lab & MedH data start from ( f20:g26) and you want to sum
(b3:b9) on budget sheet then try

=SUMIFS(BudgetSheet!$B$3:$B$9,$F$20:$F$26,"y",$G$2 0:$G$26,"y")+SUMIFS(BudgetSheet!$C$3:$C$9,$G$20:$G $26,"y",$F$20:$F$26,"y")

if you are not using 2007 then try sumproduct approach

=SUMPRODUCT(((F20:F25="Y")*(G20:G25="Y")*(BudgetSh eet!B3:B8))+((F20:F25="Y")*(G20:G25="Y")*(BudgetSh eet!C3:C8)))


adjust references accordingly.


"Andi" wrote:

I need to create a formula that will find a "Y" value in multiple fields and
then find the Monetary value associated with these fields and then give a
total.

Example, If there is a Y under Lab and MedHx, find the cost for each on the
Budget sheet, then total the values in Visit Cost.

Is this possible?

Thanks