My Assistant
Site Message (Message will auto close in 2 seconds)
Custom Search
|
  |
 Sumif Based On Specific Criteria In Two Columns, Any Version |
 Nov 12 2019, 09:53 AM Post#1 | |
Posts: 280 Joined: 8-November 03 From: Little Rock, AR  | Would the sumif function be the best approach for the following? If column 1 = "January" and Column 2 = "Yes" Then sum the total $ entered in column 3 I'm having a hard time wrapping my head around how this would look? Any help would be appreciated! Thanks |
 |  |
| Nov 12 2019, 10:08 AM Post#2 | |
 UtterAccess Moderator Posts: 11,870 Joined: 6-December 03 From: Telegraph Hill | Use SUMIFS() If your column 1 is Column 'A', column 2 is Column 'B' and column 3 is Column 'C', then something like: =SUMIFS(C1:C:20, A1:A20, "January", B1:B20, "Yes") hth, d -------------------- Regards, David Marten |
| |
| Nov 12 2019, 01:26 PM Post#3 | |
Posts: 280 Joined: 8-November 03 From: Little Rock, AR | Thanks. I think this worked. It's just pulling in the sum as "0". Not sure why but I think that is another issue. |
| |
| Nov 12 2019, 01:28 PM Post#4 | |
UtterAccess Moderator Posts: 11,870 Joined: 6-December 03 From: Telegraph Hill | Do you have an example of your data? -------------------- Regards, David Marten |
| |
| Nov 13 2019, 10:28 AM Post#5 | |
 Posts: 156 Joined: 11-October 18 | Two most likely possibilities are: 1. No data actually matches your criteria (eg the month is actually a date formatted to just show the month) 2. The data in column C is stored as text (eg if you see a $ or comma in the value in the formula bar with one of the column C cells selected, then it's text.) |
| |
|
Custom Search
|
 | Search Top Lo-Fi | 7th December 2019 - 06:12 AM |