ClioSport.net

Register a free account today to become a member!
Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

  • When you purchase through links on our site, we may earn an affiliate commission. Read more here.

Excel Help



  dCi 65 + C2 (<Sold)
156z6e8.jpg


Ok, been asked by a user if he can get a formula to add up all the 1's next to a specific date and put the number beside the specific date at the bottom. I have no idea as Excel is my absolute weak spot when it comes to support. Any help would be greatly appreciated. Thanks.
 
  Hyundai i40
you will prob need a 'sumif' formula

Click on the little Fx thing at the top it will bring up a wizard
 
  dCi 65 + C2 (<Sold)
That seems about right Sarah. How do I get it to add 1 when it comes across a 2011 though?

Rage = F1:F241
Criteria = 2011
Sum_Range = blank
 
  E92 330
i would use VLOOKUP, once a range is defined the formulae will look for a spefic date, you can then do what you please with the value.
 
  Hyundai i40
vlookup wouldnt work, as it looks only whats in the cell and gets easily confused

its doesnt add up iirc
 
  dCi 65 + C2 (<Sold)
Nope.

What I did was use the YEAR command to change the 1's to an actual year, then use the COUNTIF command to add whatever year it was up into the box next to the date at the bottom.

Thanks though guys.
 
  E92 330
This is a VLOOKUP formulae i use for something very similar, this wont work for you as you wont have a worksheet named budget nor will it have a user defined search area:

=IF(VLOOKUP(C417,Budget,2,FALSE)*F417<=0,"",VLOOKUP(C417,Budget,2,FALSE)*F417)

the 2 after the budget(worksheet name) instrucks the programme to search that colomn of data, so as long as the number relating to the date (C417 would be the location of the date) was in column 2 you wouldnt have a problem, you could also ask it to search columns 2&3 if you wanted.

I actually have this working now, unfortunately due to the nature of the content i can forward it on to you.

Go on google and search for an intermediate/professional excel guide.
 


Top