Home

Not knowing how to calculate data

Beauty1
Occasional Visitor

I have been practising how to calculate a lot of data with excel formulas but I am still the dark. In most cases I am given a lot of data in different columns and asked to calculate for example how many customers who are different in classes bought a certain product in different countries. So my problem is that I do not know how to identify all those customers in different categories using a formula

1 Reply
You would not use a formula for that ideally, but a pivot table. Alternatively, look at Help about the SUMIFS function, it will do what you require.
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