View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andi Andi is offline
external usenet poster
 
Posts: 25
Default SUM up multiple fields based on Criteria

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