Counting number of cells until a criteria is met

M

m.barnes

I have googled and searched for ever on this and all the solutions
have found do not work on my example, so please help

C / G / AA /
AB / AC / AD / AE
buy units / answer / week1 / week2 / week3 / week4 /
week
10,000 / xxx / 2,000 / 3,000 / 2,000 / 2,00
/ 3,000

Table above is a very simple example of what i have. I would like
formula that will tell me which week i get to 80% of my buy units total
So it needs to sum up until it gets to 8,000 basically then tell me th
column reference or week reference or whatever

I found a formula that worked if info was in columns not rows
I found a formula that worked as long as the answer wasnt required i
the same row as the data was

I have tried MMULT, MATCH etc etc to no avail so far

It is driving me crazy

ps sorry for the poor formatting of the example, hope its clea
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting a number of cells with 2 range criteria 3
Sum of weekly data 11
For next loop carries on after criteria is met changing other cells???? 6
CODE to select range based on User Input or Value of Input Field 4
Counting the number of returns from a query 1
Counting number of cells that make up a sum.. 2
Problems Loading Large String Array into Array variable 6
Real help is here 0

Top