UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Sumif Based On Specific Criteria In Two Columns, Any Version    
 
   
sblend63
post 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
Go to the top of the page
 
cheekybuddha
post Nov 12 2019, 10:08 AM
Post#2


UtterAccess Moderator
Posts: 11,914
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
Go to the top of the page
 
sblend63
post 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.
Go to the top of the page
 
cheekybuddha
post Nov 12 2019, 01:28 PM
Post#4


UtterAccess Moderator
Posts: 11,914
Joined: 6-December 03
From: Telegraph Hill


Do you have an example of your data?

--------------------


Regards,

David Marten
Go to the top of the page
 
Debaser
post Nov 13 2019, 10:28 AM
Post#5



Posts: 157
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.)
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    13th December 2019 - 10:47 PM