MARKEGANDERSON
Active Member
- Joined
- Apr 7, 2007
- Messages
- 264
Hello all,
I have 5 columns that I want to count all data that matches my criteria.
I want a total of all NMC and FMC (Col D) if Col A Matches Afghan, Col B matches CJOA, Col C matches GEN-CAP,Col F matches 0<99
Data ranges from Col A-F, rows 6-11650...
Will a =If(And( work?
Please Help
Col A Col B Col C Col D Col E Col F
Project Site Description Activity FMC/NMC KW Rating
Afghan CJOA GEN-CAP A-Primary NMC 200<299
Afghan CJOA LIGHT-GFE A-Primary NMC 0<99
Afghan CJOA GEN-CAP A-Primary NMC 100<199
I have 5 columns that I want to count all data that matches my criteria.
I want a total of all NMC and FMC (Col D) if Col A Matches Afghan, Col B matches CJOA, Col C matches GEN-CAP,Col F matches 0<99
Data ranges from Col A-F, rows 6-11650...
Will a =If(And( work?
Please Help
Col A Col B Col C Col D Col E Col F
Project Site Description Activity FMC/NMC KW Rating
Afghan CJOA GEN-CAP A-Primary NMC 200<299
Afghan CJOA LIGHT-GFE A-Primary NMC 0<99
Afghan CJOA GEN-CAP A-Primary NMC 100<199