Gareth McKee
asked on
excel equation to add up number based on the entry in a different cell
Hi,
this is what I want to achieve.
G3:G10 is a list of sub totals
H3:H10 is a list of 'yes' and 'no' as to whether the item is required on first sales or 2nd project complete sales
G16 is a running total of initial sale
G17 is a running total of 2nd project complete sales
How to I get G16 and 17 to self 'add up' given the data in G3:G10 and H3:H10
Thanks
Gareth
this is what I want to achieve.
G3:G10 is a list of sub totals
H3:H10 is a list of 'yes' and 'no' as to whether the item is required on first sales or 2nd project complete sales
G16 is a running total of initial sale
G17 is a running total of 2nd project complete sales
How to I get G16 and 17 to self 'add up' given the data in G3:G10 and H3:H10
Thanks
Gareth
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You are a genius!!
Can you post your sample file along with data or result what you are looking for as i'm not sure what you are looking here to do..
Saurabh...