Sum and Count on a criteria range

[Swifey]

I want to create a summary of how many card holders have spent over a certain amount and the sum of sales value. Is there a formula that will count and sum certain criterias.

for example my data is as follows
Card_Holder,,,Sales Value
0000159309,,,297974.34
0000500363,,,255251.28
0000158760,,,152886.95
0000159430,,,113783.17
0000159409,,,91722.89
0000159784,,,56038.08
0000159251,,,55920.18
0000159097,,,55809.52
0000158398,,,47314.29
0000157188,,,41827.19
0000156659,,,36249.22
0000157849,,,30939.84
0000158397,,,27791.01
0000162057,,,26113.84
0000160475,,,25757.16
0000158776,,,25498.18

Example of Summary I want to produce
Spend Range,,,,,,,,,,,,,,,,,,,,,,,,,,,,No,,,,,,,,,,,Value
Spend £100,000 plus,,,,,,,,,,,,,,,,,4,,,,,,,,,,,,,819895.74
Spend £50k - £99,999k,,,,,,,,,,,,,4,,,,,,,,,,,,,259490.67
Spend £25k - £49,999k,,,,,,,,,,,,,8,,,,,,,,,,,,,261490.73


Thank you
Swifey

 

[nevillestoke]

Following on Aladin's response (he's faster than me once again) if you need this information in only one cell, you could enter a formula such as:

="No. of Card Holder's with sales greater than "&TEXT(E4,"000,000")&" is "&TEXT(F4,"0")&" for a value of "&TEXT(G4,"000,000")

This can be placed anywhere to provide the number and amount over 100,000

To include a similar statement for sales between 50,000 and 99,999 use:

="No. of Card Holder's with sales between "&TEXT(E3,"00,000")&" and "&TEXT(E4-1,"00,000")&" is "&TEXT(F3,"0")&" for a value of "&TEXT(G3,"000,000")

I hope this helps

 

[Swifey]

Thank you
Swifey