Thanks.

Both the SUMProduct and SUMIF solutions here work for me.

"Paul C" wrote:

Something like this
=sumproduct(--(A1:A5="Y"),B1:B5)+sumproduct(--(c1:c5="Y"),D1:D5)

in this simple example the Y/N values are in columns A and C and the
corresponding data in columns B and D

when using the --(A1:A5="Y") condition true values are 1 and false values
are 0, so this sums only what you want.

Change the ranges as needed (can be on other sheets)
like this =SUMPRODUCT(--(Sheet2!B2:B3="Y"),Sheet3!C2:C3)

This should do the trick
--
If this helps, please remember to click yes.


"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