Need help with creating formula

Occasional Visitor

Hello and thank you for your time.

I am wanting to create a formula similar to a IF formula. I have used IF formulas as simple as =IF(A1="January",+B1,0). What I am trying accomplish is a similar function but the A1 to be a range of cells it looks up to see if they say "January" then if true add together other cells. Example I have tried but wont work =IF(A1:A10="January",+B1:B10). We farm and I keep track of our grain sales by month and how many bushels we have sold each month, that's why I am trying to get a formula to look up in a range and if it says January then it adds the amount of bushels we have sold for January in one cell instead of a table. Thank you very much for your time. I am happy to share my worksheets if that would help anyone

1 Reply



Try SUMIFS() or even better use a pivot table.


Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
48 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies