sum figures separately on different sheet in a workbook

[tosinbolaji]

Hello, Please i need your help anyone. I have a multiple sheet containing transactions from different client and a colum showing revenue for each of this client. I will like to get the total per client on each sheet separately.

 

[igold]

Hi tosinbolaji,

Welcome to the MrExcel Forum.

It sounds like you should use SUMIFS. But since we cannot see your sheet and we have no idea how your data is laid out, it is impossible to accurately answer your question as it is phrased now.

Perhaps you may want to either be more descriptive in your question including cell references and sheet names or better yet provide a representative graphic sample of your worksheet.

Just a thought.