Lunchtime Excel Help!
Author
Discussion

S 8 GRN

Original Poster:

1,198 posts

274 months

Friday 30th April 2010
quotequote all
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

FlossyThePig

4,143 posts

274 months

Friday 30th April 2010
quotequote all
=SUMIF(A1:D1,">0",A2:D2)

TonyHetherington

32,091 posts

281 months

Friday 30th April 2010
quotequote all
Depending on whether it's blank or 0 you may need to use "" instead of >0, but other than that what the guy above says is what you'll be needing smile

S 8 GRN

Original Poster:

1,198 posts

274 months

Friday 30th April 2010
quotequote all
Legendary service - thank you very much.