itsgrady
Board Regular
- Joined
- Sep 11, 2022
- Messages
- 132
- Office Version
- 2021
- Platform
- Windows
- MacOS
=SUMPRODUCT(--(vpi!F:F="Apple Green"),vpi!K:K)+SUMPRODUCT(--(vpi!F:F="Redfish"),vpi!K:K)+SUMPRODUCT(--(vpi!F:F="Dark Blue"),vpi!K:K)+SUMPRODUCT(--(vpi!F:F="Green"),vpi!K:K)
=COUNTIF(vpi!F:F, "Acid")
SUMPRODUCT - The above formula works well in adding the weight (vpi!K:K) of the following items for one line on the spreadsheet:
COUNTIF - The above formula works for one line on the spreadsheet but I need the same information but I don't want to count anything in a different column and sheet (vpi!N:N) that has "TT" in the column. How can I add to this formula to accomplish this?
Thanks for the needed help.
=COUNTIF(vpi!F:F, "Acid")
SUMPRODUCT - The above formula works well in adding the weight (vpi!K:K) of the following items for one line on the spreadsheet:
- Apple Green
- Redfish
- Bark Blue
- Green
COUNTIF - The above formula works for one line on the spreadsheet but I need the same information but I don't want to count anything in a different column and sheet (vpi!N:N) that has "TT" in the column. How can I add to this formula to accomplish this?
Thanks for the needed help.