LinkBack URL
About LinkBacks
I'd like a little formula that finds all the 4012 codes in the UK and totals the gifts. Can a SUMIF be tricked to count two variables? The answer in this instance would be $270
Please Login or Register to view this content.
I'd like a little formula that finds all the 4012 codes in the UK and totals the gifts. Can a SUMIF be tricked to count two variables? The answer in this instance would be $270Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Maybe
VBA Noob=SUMPRODUCT((A1:A100=4012)*(B1:B100="UK")*(C1:C100))
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Perfect! Thanks so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks