This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Excel Wizards
I need a formula but cannot figure it out, maybe it is not possible or maybe you can help me out. The snapshot of the spread sheet is used to report totals of people served at a local food pantry I volunteer at. I am trying to total the green space in H13, I 123, J13, but only if column E and or F has a 1. Example: F5 has a1 so I want J5 counted in the sum at J13, but E6 and F6 have no marking so would not be counted in J13. So in this example I13 would count 3 and J13 would count 5 Any help would be greatly appreciated. Mike
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
In H13:
=SUM(H4:H11*($E4:$E11+$F4:$F11>0))
Fill to the right to I13 and J13,