Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
MS Excel - How to count values of a different column using =count formula?
Here’s what I have…
In column A I have random dates… In column B I have random numbers
I am trying to do a formula that states…. If Column A’s date = X (example 06/30/10) then add the value of the entry in column B.
Something like… =if(A:A=06/30/10, count(B:B)…. I don’t know… I’m lost…
5 Answers
- IXL@XLLv 71 decade agoFavorite Answer
Try this
C1 =SUMIF(A:A,">"&C2,B:B) where C2 contains the date you wish to total
Col A is date, col B are numbers
- 1 decade ago
Probably the easiest way would be to sort the rows by date, and then find the ones with 06/30/10 and just sum the values in column B.
- garbo7441Lv 71 decade ago
The function you are looking for is the SUMPRODUCT function. Using your columns above, this formula would sum the totals in column B for values in column A displaying '6/30/10':
=SUMPRODUCT((A1:A100=DATE(2010,6,30))* (B1:B100))
If you wanted to make this formula 'variable' in the sense you could key in a date in a separate cell and have the formula sum values for that date:
=SUMPRODUCT((A1:A100=D1)* (B1:B100))
Then, whatever date you enter in cell D1 will be summed and displayed by the formula.
- 1 decade ago
Don't get your point. what you want to do here Column B got random numbers what you want to add in it. I think you should try vlookup formula.
- Anonymous5 years ago
WOW. I would definitely say she needs help! It sounds like shes on a manic upswing. If the downswing is in proportion, I would be looking for help for her with her family! Its gonna be a doozy! She makes herself sound so unrealistically perfect in her writeup. Its interesting to read but you definitely have a reason to be concerned.
