[Solved] Using IF Function

[shaoen01]

Hi all,

I would like to do a SUM function based on the status of the column. For example, each row has an amount and status (E.g. Complete, Incomplete, etc). I would like to total up all the rows based on their status like all amounts with the status "Complete" for instance. Does anyone know how i can do that? Thanks

[RonIA]

Have you looked at SUMIF?

[acknak]

Follow the link for a little example from another question; maybe it will help here:

http://www.oooforum.org/forum/viewtopic ... 066#265066

[shaoen01]

Hi,

Thanks i manage to find what i was looking for!