Forum

Notifications
Clear all

Sumifs with data in horizontal and vertical

7 Posts
3 Users
0 Reactions
163 Views
(@hava)
Posts: 41
Trusted Member
Topic starter
 

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 ( ) I´m sent an example for my doubt (error calculation you see that)- sum with conditions in horizontal and vertical data.

 

Many thanks.

 

Hava

 
Posted : 30/12/2016 8:42 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Hava

See if this is what you wanted.

Sunny

 
Posted : 30/12/2016 11:19 am
(@fravis)
Posts: 337
Reputable Member
 

And as an extra with drop down list! 🙂

 
Posted : 31/12/2016 5:07 am
(@hava)
Posts: 41
Trusted Member
Topic starter
 

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

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

 
Posted : 31/12/2016 11:56 am
(@hava)
Posts: 41
Trusted Member
Topic starter
 

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!

 
Posted : 31/12/2016 12:00 pm
(@sunnykow)
Posts: 1417
Noble Member
 

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

 
Posted : 31/12/2016 12:08 pm
(@fravis)
Posts: 337
Reputable Member
 

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.

 
Posted : 31/12/2016 4:06 pm
Share: