How to make an excel formula which totals several agecent rows based on cell values
Posted
by Yishai
on Super User
See other posts from Super User
or by Yishai
Published on 2009-12-28T16:18:42Z
Indexed on
2010/04/07
11:33 UTC
Read the original article
Hit count: 486
excel-2007
|formula
I have an excel sheet with three columns: date, person and percentage. I would like to put in a data validation that flags cells if the total for a given data/person combination do not equal 100%. Is that possible?
In other words, in the custom formula of a data validation, I would like to make the following type of formula.
=if(sum( cells with a (date = the date on this row, person = person on this row))=1)
Is there a function which will return the cells in a range conditioned on certain values, or will sum the cells.
Note that if it is not possible to do two cells, I have no issue adding a cell which combines both values for the purpose of effecting the lookup.
© Super User or respective owner