• 463K Members
• 7,285 Online
• 560K Conversations

New Contributor

# SUMIFS formula help

I currently use this formula

=SUMIFS(Transactions!\$F\$3:\$F\$17,Transactions!\$K\$3:\$K\$17,"7508")

This will search a worksheet for the number 7508 in a column K and then add all of the costs in Column F if column K returns the correct data.

We have thousands of codes - up to 8500 so at the moment i work out which codes are in the transactions worksheet and then manually change each formula

What i want to be able to do is in my work sheet enter the codes into a coloumn and have the formula automatically change do in my above formula i want 7508 to actually be cell reference so i can change what data is in the cell and searched for eg change it to 4011 and have the formula return the total amount of any entries using that code

hope that makes sense!!

# Re: SUMIFS formula help

Hi

So rather than hardcoding 7508 just type '7508 into cell A1 and change your formula to

=SUMIFS(Transactions!\$F\$3:\$F\$17,Transactions!\$K\$3:\$K\$17,A1)

Just an extra question - is a Pivot Table not a suitable solution in this scenario?
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 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
29 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