alfredmaul
New Member
- Joined
- Jul 17, 2019
- Messages
- 4
Hi,
I am close to my answer but, despite searching, keep missing the mark. I think it is an easy fix and appreciate the help. The gist is: I can't figure out the syntax for SUMPRODUCT to work across multiple tables if some of that data contains text. I would prefer to keep the answer as simple and readable as possible. I likely just need to rewrite the SUMPRODUCT to include those "--" things.
In the screenshot from this link -- https://i.imgur.com/TbfCmJN.png -- you can see there are multiple tables for each month. Sometimes the data will have information for column 2, 3, etc, and sometimes not. But I need to retain the ability to sort it independently within each month.
It's something like =SUMPRODUCT(--(C3:I45=P3),F3:F45) right, or throwing the -- before F3:F45?
Thanks!
I am close to my answer but, despite searching, keep missing the mark. I think it is an easy fix and appreciate the help. The gist is: I can't figure out the syntax for SUMPRODUCT to work across multiple tables if some of that data contains text. I would prefer to keep the answer as simple and readable as possible. I likely just need to rewrite the SUMPRODUCT to include those "--" things.
In the screenshot from this link -- https://i.imgur.com/TbfCmJN.png -- you can see there are multiple tables for each month. Sometimes the data will have information for column 2, 3, etc, and sometimes not. But I need to retain the ability to sort it independently within each month.
- =SUMPRODUCT((C3:I45=P3)*F3:F45) works across multiple tables but when it encounters the text in F33, it messes up with a #VALUE ! error. How do I use those "--" things or IFERROR to ignore it? I am very close...
- =SUMIF(C3:H58,P8,F3:F58) will ignore the F33 error, but it only lets me search/input text from column C. Is there a way to expand the SUMIF to look for the "P8" across more than one column? SUMPRODUCT formula finds "wages" and gives me the total from but SUMIF does not.
It's something like =SUMPRODUCT(--(C3:I45=P3),F3:F45) right, or throwing the -- before F3:F45?
Thanks!