Link to home
Start Free TrialLog in
Avatar of Gareth McKee
Gareth McKeeFlag for Canada

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
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Gareth ,

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...
ASKER CERTIFIED SOLUTION
Avatar of Wayne Taylor (webtubbs)
Wayne Taylor (webtubbs)
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Gareth McKee

ASKER

You are a genius!!