My Online Training Hub

Microsoft Office Online Training

Get our newsletter and join over 80,000
people who learn Excel with us every week
You are here: Home / Sumifs with data in horizontal and vertical | General Excel Questions & Answers | Excel Forum

Sumifs with data in horizontal and vertical | General Excel Questions & Answers | Excel Forum

Avatar
sp_Registration Register sp_LogInOut Log In sp_ControlOpen Unanswered
sp_Search Search
Advanced Search
Search

— Forum Scope —





— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Search Search
sp_RankInfo

Lost password?
sp_PrintTopic sp_TopicIcon
Sumifs with data in horizontal and vertical
Avatar
Hava Yassin
Member
Members
Level 0
Forum Posts: 37
Member Since:
December 29, 2016
sp_UserOfflineSmall Offline
1
December 29, 2016 - 10:42 pm
sp_Permalink sp_Print sp_EditHistory

Hello! 

I searched in our website , but I´m not find this tool for my task.

and I´m not find any webinar about this, can help please?  In this file attached or in this link (https://snag.gy/4swMAu.jpg) I´m sent an example for my doubt (error calculation you see that)- sum with conditions in horizontal and vertical data.

 

Many thanks.

 

Hava

sp_AnswersTopicSeeAnswer See Answer
Avatar
SunnyKow
Malaysia
Member
Members

Dashboards
Level 6
Forum Posts: 704
Member Since:
June 25, 2016
sp_UserOfflineSmall Offline
2
December 30, 2016 - 1:19 am
sp_Permalink sp_Print

Hi Hava

See if this is what you wanted.

Sunny

sp_AnswersTopicAnswer
Answers Post
Avatar
Frans Visser
Duivendrecht (near Amsterdam) - The Netherlands
Member
Members

Dashboards

Power BI

Power Query
Level 1
Forum Posts: 224
Member Since:
April 21, 2015
sp_UserOfflineSmall Offline
3
December 30, 2016 - 7:07 pm
sp_Permalink sp_Print

And as an extra with drop down list! 🙂

Avatar
Hava Yassin
Member
Members
Level 0
Forum Posts: 37
Member Since:
December 29, 2016
sp_UserOfflineSmall Offline
4
December 31, 2016 - 1:56 am
sp_Permalink sp_Print

Frans Visser said
And as an extra with drop down list! 🙂  

Hello Frans Visser! I don´t understand your answer! Thanks

Avatar
Hava Yassin
Member
Members
Level 0
Forum Posts: 37
Member Since:
December 29, 2016
sp_UserOfflineSmall Offline
5
December 31, 2016 - 2:00 am
sp_Permalink sp_Print

SunnyKow said
Hi Hava

See if this is what you wanted.

Sunny  

Hello Sunny!

Yes!!! It´s so useful!! Many Thanks and Happy New Year!

Avatar
SunnyKow
Malaysia
Member
Members

Dashboards
Level 6
Forum Posts: 704
Member Since:
June 25, 2016
sp_UserOfflineSmall Offline
6
December 31, 2016 - 2:08 am
sp_Permalink sp_Print

Hi Hava

Nice to know it is useful to you.

What Frans Visser meant was that I created a drop down list for you to choose instead of keying in.

Happy New Year to you too HavaLaugh

Sunny

Avatar
Frans Visser
Duivendrecht (near Amsterdam) - The Netherlands
Member
Members

Dashboards

Power BI

Power Query
Level 1
Forum Posts: 224
Member Since:
April 21, 2015
sp_UserOfflineSmall Offline
7
December 31, 2016 - 6:06 am
sp_Permalink sp_Print

SunnyKow said 

"..........What Frans Visser meant was that I created a drop down list for you to choose instead of keying in................." 

Exactly!

I love those little 'extra's' when somebody asks for help and a solution. You not only help but give them also some more. Very nice and gentle and I hope we all learn more this way.

Go to top
Forum Timezone: Australia/Brisbane

Most Users Ever Online: 57

Currently Online: azri adrin, Mark Lund, Rudi
19 Guest(s)

Currently Browsing this Page:
2 Guest(s)

Top Posters:

SunnyKow: 651

Frans Visser: 210

David_Ng: 96

mey tithveasna: 71

A.Maurizio: 60

rathanak: 58

yhooithin05: 54

Anders Sehlstedt: 47

julian: 46

PaulFogel: 37

Newest Members:

Ajay Mukhi

Stephen Motte

Rodney Hoyle

michael pitre

Samantha Burleson

Krishnaa Kurugod

David McSwain

Shameem Nassiree

Alanna Henderson

Janel Oz

Forum Stats:

Groups: 2

Forums: 18

Topics: 935

Posts: 4405

 

Member Stats:

Guest Posters: 1

Members: 42350

Moderators: 1

Admins: 3

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea

Moderators: Genevieve Tupas

YouTube Channel Follow us on Facebook Twitter Follow Google+ RSS Feed or Email

Blog Categories

Resources

Excel Resources

Affiliate Program

Become an Affiliate
Secured by Sucuri Rect
✕
Hang On, Don't Go Just Yet.
Excel Tips & Tricks Book

As a thank you for visiting how would you like a
10% Discount Code to use with any of my courses?

I'll also give you a copy of my eBook packed with
100 Excel Tips & Tricks.

And I'll send you my weekly Excel blog posts.

Enter your email address below to receive all of these.

Regards, Mynda (Excel MVP)

mynda treacy mvp
100% Privacy. We don't spam.
✕
SUBSCRIBE AND LEARN EXCEL
Excel Tips & Tricks Book


Learn great Excel features, tips and tricks each week from my newsletter.

Just enter your email below, and as an extra bonus, I'll send you a copy of my '100 Excel Tips & Tricks eBook' - for nothing!

Thanks,

Mynda

 



100% Privacy. We don't spam.
✕
100 FREE EXCEL TIPS & TRICKS
Excel Tips & Tricks Book


Want to learn more great Excel tips and features?

Enter your email below and I'll send you my weekly blog post.

Plus, by signing up you'll get a copy of my '100 Excel Tips & Tricks eBook' - for nothing!




 

100% Privacy. We don't spam.