Hi,
Simple formula I am having a bit of trouble with.
In the workbook I am trying to summarise the data in the MAY sheet on the DATA sheet.
What is the right formula to use to count the number of instances a client has not renewed.
There are 7 reasons why and I would like to tally these up into the table on the DATA sheet.
I have tried SUMPRODUCT & COUNTIF but for some reason cannot get it to work.
Any help would be appreciated.
ThanksSample.xlsx
tRY:
=COUNTIF(May!$C$6:$C$23,F$5)
If you want to refer to the sheet, indirectly using column E months...
=COUNTIF(INDIRECT("'"&$E6&"'!C6:C23"),F$5)
copied down and across
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
In C15 you have a space after the text ("ONG "), which probably is the reason why your =COUNTIF() doesn't work. You could try this in F6 and copied across:
Formula:
Please Login or Register to view this content.
Sincerely
S?ren Larsen
"Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"
Hello gtudor,
Try what I have in the attached workbook.
Let me know if this helps.
Steve
A VBA novice, excited to learn!
Great, thank you very much
Glad to help! Could you help by marking this thread as solved?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks