SUMIF nesting an AND function
Hi kraymond,
In your example it looks like Legislative has no preceding spaces; and that
Salaries & Wages, Benefits, etc. do - to indent them.
To determine if something is Legislative or Finance, in D2:
=IF(A2="","",IF(ISERROR(FIND(" ",A2,1))=TRUE,A2,D1))
Copy this formula down in column D for all rows with corresponding data.
=SUM(IF((A:A=" Salaries & Wages")*(D:D="Legislative"),L10:L20))
enter this formula with Ctrl+shift+enter
Hope this helps
"kraymond" wrote:
Hi, I'm not exactly sure how to do this. I want to sum data in column c if it
meets two conditions, both in column a. For example, I have budget data in
column a; formatted as:
Legislative
Salaries & Wages
Benefits
etc.
Finance
Salaries & Wages
Benefits
etc.
The actual budget number is in column C. I want to summarize the data by
saying that if column a is both legislative and benefits, sum column c.
Is there a good way to do this? Thanks all!
Kassandra
|