Hi,
I need a formula to help some with counting boxes.
I need something like
If a client is is repeated, in column a, then add all the totals, in column b.
If it helps I can upload a spread sheet in order to explain further.
Thanks
Hi,
I need a formula to help some with counting boxes.
I need something like
If a client is is repeated, in column a, then add all the totals, in column b.
If it helps I can upload a spread sheet in order to explain further.
Thanks
It always helps to upload a sample, but you'll want something like this:
=IF(COUNTIF(A:A,A1)>1,SUMIF(A:A,A1,B:B),B1)
SPARTAN
Please click the * if my solution helped
Since you asked for a running total, I think this formula will work:
=IF(A2=A1,B2+C1,B2)
This is assuming all of the clients are grouped together. If they are not grouped together, something more complex is required.
I knew with a bit of work I could figure out the formula for a running total of unordered Clients. Here you go:
=IF(COUNTIF($A$1:$A1,$A1)>0,SUMIF($A$1:$A1,$A1,$B$1:$B2),$B1)
Last edited by Melvinrobb; 07-13-2012 at 12:43 PM. Reason: Added Formula
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks