question

[krayot]

I have a table - in one column I have days I worked - it doesnt come in order - which means - sun, wed, fri, thu, sun, sat ... etc.
this column is endless.
in the second column I have a number 5,7,7,6,3,9 etc ...
I want that the function will look for all the "sun" days and will SUM all the numbers near. how do I do that ?

[EdMac]

Use the SUMIF function - excel help describes it well

Ed

[krayot]

thanks, but SUMIF has nothing to do with it.
again - I need a function that will look which number has near "sun" and add it to the next one. for example:

sun - 3
mon - 5
fri - 6
sun - 9
thu - 2
sun - 6

the function will look for all the "sun" - and SUM it to - 3 + 9 + 6 =

[EdMac]

Oh yes it does

for example, if your days are in col A and the hours in col B and your data extends A2 to A30 then

=SUMIF(A2:A30,"sun",B2:B30)

will sum all the entries that are next to "Sun".

or maybe i have misunderstood you and you want to do something different?

Ed

[krayot]

you are damn right !!

I was using a formula that look like:
=SUMPRODUCT((INDIRECT("$B$10:$B$"&COUNTA($B:$B))=$B2)*(INDIRECT("C$10:C"&COUNTA($B:$B))))
and I see now that it is not true ... I'm stunned !

THANKS

[EdMac]

Hi krayot,

that's OK - it's quite often a case of not being able to see the wood for the trees.

The old KISS adage (keep it simple, stupid) often applies!

Glad you are sorted - feel free to post back if you have any more problems.

Ed