ExcelBanter - what formula for summing if two logical statements are true?

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

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

- - what formula for summing if two logical statements are true? (https://www.excelbanter.com/excel-worksheet-functions/185578-what-formula-summing-if-two-logical-statements-true.html)

steve95959

what formula for summing if two logical statements are true?

I am trying to automatically sum numbers in a spreadsheet according to person
and project task - so what formula do I use to sum #s with if two logical
statements are true, e.g, if d16:d60 = "Kelly" and e16:e60 = "tasks 1.5"?

Dave

what formula for summing if two logical statements are true?

Hi,
Try
=IF(AND(D16:D60 = "Kelly", E16:E60 = "tasks 1.5"),SUM(YourRange),"")
Change YourRange for the cells you want to Sum.
Regards - Dave

"steve95959" wrote:

I am trying to automatically sum numbers in a spreadsheet according to person
and project task - so what formula do I use to sum #s with if two logical
statements are true, e.g, if d16:d60 = "Kelly" and e16:e60 = "tasks 1.5"?

Teethless mama

what formula for summing if two logical statements are true?

=SUMPRODUCT(--(D16:D60="Kelly"),--(E16:E60="tasks 1.5"),SumRange)

"steve95959" wrote:

I am trying to automatically sum numbers in a spreadsheet according to person
and project task - so what formula do I use to sum #s with if two logical
statements are true, e.g, if d16:d60 = "Kelly" and e16:e60 = "tasks 1.5"?

All times are GMT +1. The time now is 01:17 AM.