windsurfit
Board Regular
- Joined
- Mar 27, 2003
- Messages
- 228
I have a sheet with multiple columns of data.
I would like to have a Subtotal value returned (in cell F3) based on the text entry in a given range - Column J and the corresponding numeric value in Column K
So for example when J9 has the Word "Current" and K9 has the value 100.00 then F3 will result and display $100.00
when J9 has the word 'Prospect" and K9 has the value 100.00 then F3 will result and display $0.00
This is for all data on all rows as my database grows where it finds the "matched" text.
Suggestions??
I would like to have a Subtotal value returned (in cell F3) based on the text entry in a given range - Column J and the corresponding numeric value in Column K
So for example when J9 has the Word "Current" and K9 has the value 100.00 then F3 will result and display $100.00
when J9 has the word 'Prospect" and K9 has the value 100.00 then F3 will result and display $0.00
This is for all data on all rows as my database grows where it finds the "matched" text.
Suggestions??