ExcelBanter - Is there an easy way calculate 2 variables in conditional sum wiz.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Is there an easy way calculate 2 variables in conditional sum wiz. (https://www.excelbanter.com/excel-worksheet-functions/6079-there-easy-way-calculate-2-variables-conditional-sum-wiz.html)

Liketoknow

Is there an easy way calculate 2 variables in conditional sum wiz.

I have a great amount of data to calculate each day,,i am trying to find a
way to sort out bad data eg( i need to sort out any data that is less
than 0 or more than 2 etc)
I am trying to use conditional sum wizard

Frank Kabel

Hi
why not use 'Data - Filter' for this?

"Liketoknow" wrote:

I have a great amount of data to calculate each day,,i am trying to find a
way to sort out bad data eg( i need to sort out any data that is less
than 0 or more than 2 etc)
I am trying to use conditional sum wizard

All times are GMT +1. The time now is 05:51 PM.