=SUMIF(BOMS!D$7:D$692, A23, BOMS!G$7:G$692)

Hi Hans thanx I have fixed this now it was some of the other code that was causing the issue if it not summing properly is all good now thanx for the reply also 👍

Join us June 17–18 for a deep dive into Copilot Control System—live expert-led sessions and Q&A on data security, agent lifecycle, adoption, and more! Learn more >

Forum Discussion

AUSSIEBLOKE72

Copper Contributor

May 27, 2025

RE SUM IF WITH FORMULAS IN CELLS Hi I want to sum all in column G on the BOMS sheet.

excel

2 Replies

HansVogelaar
MVP
May 27, 2025
=SUMIF(BOMS!D$7:D$692, A23, BOMS!G$7:G$692)
- AUSSIEBLOKE72
  Copper Contributor
  May 28, 2025
  Hi Hans thanx I have fixed this now it was some of the other code that was causing the issue if it not summing properly is all good now thanx for the reply also 👍