Lunchtime Excel Help!
Discussion
Hi All,
Is anyone able to offer a solution to the following for me?
I'm looking for a formula that will count the number of cells that contain data and then go to another range and add up that number of cells worth of data.
e.g. A1 = 50 B1 = 50 C1 = 50 D1 = blank
So I want this to return a value of 3 (probably using countif)
I then want to go to the next series of data:-
A2=100 B2=100 C2=100 D2=100
And only add up the first 3 cells to return 300.
HELP! (god i feel thick)
Thanks in advance
Is anyone able to offer a solution to the following for me?
I'm looking for a formula that will count the number of cells that contain data and then go to another range and add up that number of cells worth of data.
e.g. A1 = 50 B1 = 50 C1 = 50 D1 = blank
So I want this to return a value of 3 (probably using countif)
I then want to go to the next series of data:-
A2=100 B2=100 C2=100 D2=100
And only add up the first 3 cells to return 300.
HELP! (god i feel thick)
Thanks in advance
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff



