View Single Post
  #7  
Old 04-17-2016, 07:50 PM
mrhasan's Avatar
mrhasan mrhasan is offline
Member
 
Join Date: Jun 2012
Location: Calgary
Posts: 2,893
mrhasan is on a distinguished road
Default

Quote:
Originally Posted by Myka View Post
THANK YOU!!! I was so close! I was screwing doing it like this:

Formula for column E4 =SUMIF(C1:C3,"X",E1:E3)
Glad I could be of help

The same thing can be achieved by various other functions. Lookup is another one they gives you more flexibility but can get a bit complicated so if you like, you can try lookup too. Youtube has great tutorials.
__________________

You wouldn't want to see my tank. I don't use fancy equipment and I am a noob
Reply With Quote