|
Replies: 18
| visibility 443
|
All-In [49026]
TigerPulse: 100%
Posts: 38804
Joined: 12/31/97
|
Anyone good with Excel formulas?
May 10, 2022, 4:28 PM
|
|
I want to write a formula that IF a particular date is in any cell in column G then the program should sum all the values in the adjacent cells of the same row of Column H and place the total value in the cell containing the formula.
|
|
|
|
 |
Oculus Spirit [81884]
TigerPulse: 100%
Posts: 47110
Joined: 3/18/07
|
Sounds like =SUMIF() command?***
May 10, 2022, 4:29 PM
|
|
|
|
|
|
|
|
All-In [49026]
TigerPulse: 100%
Posts: 38804
Joined: 12/31/97
|
Let's presume that I am even more novice than that...
May 10, 2022, 4:31 PM
|
|
meaning I used to be pretty okay at it when I was in business school, but that was 30 years ago.
|
|
|
|
|
|
Oculus Spirit [81884]
TigerPulse: 100%
Posts: 47110
Joined: 3/18/07
|
|
|
|
|
|
All-In [49026]
TigerPulse: 100%
Posts: 38804
Joined: 12/31/97
|
I have a spreadsheet to keep track of settlements
May 10, 2022, 4:40 PM
|
|
It started simply. It was just a list. THen I started putting in formulas to sum and divide. Then I made a place where I could write a check date and IF there was any value in that cell (say e5), the formula would place the value from c5 into f5. The values in column E are dates. I want to make it so that it will look for a date in any row in Column E, and then SUM the cooresponding numbers from column F.
|
|
|
|
|
|
All-In [42833]
TigerPulse: 100%
Posts: 10435
Joined: 3/1/18
|
Insert --> PivotTable***
May 10, 2022, 10:03 PM
|
|
|
|
|
|
|
|
All-In [49026]
TigerPulse: 100%
Posts: 38804
Joined: 12/31/97
|
Actually, as I started working that out in my head...
May 10, 2022, 4:33 PM
[ in reply to Sounds like =SUMIF() command?*** ] |
|
I think I could futz around and get most of it, but how to get it to SUM E6, E9 and E22 IF that row number happens to be where "4/15/2022" appears in column G?
|
|
|
|
|
|
All-TigerNet [11203]
TigerPulse: 100%
Posts: 14766
Joined: 6/29/01
|
You only want to add 3 cells if a specific date is in column G?
May 10, 2022, 4:53 PM
|
|
|
|
So something like this?
Message was edited by: jroberts®
|
|
|
|
|
|
All-In [49026]
TigerPulse: 100%
Posts: 38804
Joined: 12/31/97
|
If the date only appears 3 times in column g
May 10, 2022, 4:55 PM
|
|
if the date appears 10 times in g it would have sum the value of the 10 cells on the same row of column H
|
|
|
|
|
|
All-In [43650]
TigerPulse: 100%
Posts: 18071
Joined: 4/24/15
|
Yes
May 10, 2022, 4:31 PM
|
|
And I applaud your ambition. You can do anything you set your mind to!
|
|
|
|
|
|
Oculus Spirit [79183]
TigerPulse: 100%
Posts: 24915
Joined: 8/29/12
|
In Excel, dates are stored like numbers, so you can use
May 10, 2022, 4:33 PM
|
|
< or > to help out. or just subtract them.
There's a million ways to skin that cat.
|
|
|
|
|
|
All-In [31434]
TigerPulse: 100%
Posts: 10168
Joined: 1/28/15
|
Re: Anyone good with Excel formulas?
May 10, 2022, 5:27 PM
|
|
Just copy and paste this
P=NIS(69:420)
|
|
|
|
|
|
Oculus Spirit [85273]
TigerPulse: 100%
Posts: 24911
Joined: 5/21/14
|
Sorry I was late, I was working in Excel
May 10, 2022, 5:31 PM
|
|
|
|
I prefer SUMIFS, SUMIF will work also, but SUMIF is stoopid.
Also, sorry but I used different columns
|
|
|
|
|
|
Oculus Spirit [85273]
TigerPulse: 100%
Posts: 24911
Joined: 5/21/14
|
And with the explanation...
May 10, 2022, 5:33 PM
|
|
=SUMIFS($Z$3:$Z$10,$Y$3:$Y$10,V3)
Sum everything in column Z, where any of the values in column Y = V3
|
|
|
|
|
|
Heisman Winner [135801]
TigerPulse: 100%
Posts: 41610
Joined: 8/26/07
|
Very nice***
May 10, 2022, 5:59 PM
|
|
|
|
|
|
|
|
Lot o points [180965]
TigerPulse: 100%
Posts: 94611
Joined: 12/5/10
|
|
|
|
|
|
All-In [49026]
TigerPulse: 100%
Posts: 38804
Joined: 12/31/97
|
|
|
|
|
|
Heisman Winner [135801]
TigerPulse: 100%
Posts: 41610
Joined: 8/26/07
|
|
|
|
|
|
Lot o points [155776]
TigerPulse: 100%
Posts: 65773
Joined: 5/6/13
|
Format c:***
May 10, 2022, 5:55 PM
|
|
|
|
|
|
|
|
Replies: 18
| visibility 443
|
|
|
50
