Hi All,
Attached is a workbook im working on.
Tab 2- 'Raw Data' has some data in and in Tab1 'Summary', I want to collate the data in tab 2 and display how many new customers are expected per service type, per quarter in tab 1. If there is no data I want it to show '0'.
Once the data has populated in the summary table I will show it as a graph.
Can anyone help with what formula I should use to collate the data within the summary table?
Thank you
Try
in B5
=SUMIFS('Raw Data'!$F$3:$F$11,'Raw Data'!$G$3:$G$11,'Summary '!$A5,'Raw Data'!$C$3:$C$11,'Summary '!B$4)
copy across and down
Thank you for your response, that formula worked well, however I am trying to populate a slightly different workbook with the same formula and I am continuously getting errors, ive attached the workbook, are you able to help me?
thank you.
In "B18"
Formula:
Please Login or Register to view this content.
copy & paste across & down.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
This works perfectly, thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks